Oracle PL/SQL Tutorial/Collections/POWERMULTISET

POWERMULTISET Operator

You use the POWERMULTISET operator to get a sub-nested table from an input nested table. The following query illustrates the use of POWERMULTISET:

   <source lang="sql">

SQL> SQL> CREATE Or Replace TYPE nestedTableType IS TABLE OF VARCHAR2(10)

 2  /

SQL> SQL> SELECT *

 2  FROM TABLE(POWERMULTISET(nestedTableType("This", "is", "a", "test")));

COLUMN_VALUE

---

nestedTableType("This") nestedTableType("is") nestedTableType("This", "is") nestedTableType("a") nestedTableType("This", "a") nestedTableType("is", "a") nestedTableType("This", "is", "a") nestedTableType("test") nestedTableType("This", "test") nestedTableType("is", "test") nestedTableType("This", "is", "test") nestedTableType("a", "test") nestedTableType("This", "a", "test") nestedTableType("is", "a", "test") nestedTableType("This", "is", "a", "test") 15 rows selected. SQL> SQL> drop type nestedTableType; You cannot use POWERMULTISET in PL/SQL.</source>