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>