SUBMULTISET operator checks whether the contents of one nested table are a subset of another nested table.
SQL>
SQL> CREATE OR REPLACE PROCEDURE submultiset_example AS
2 TYPE nestedTableType IS TABLE OF VARCHAR2(10);
3 myTable1 nestedTableType;
4 myTable2 nestedTableType;
5 myTable3 nestedTableType;
6 result BOOLEAN;
7 BEGIN
8 myTable1 := nestedTableType('A', 'G', 'S');
9 myTable2 := nestedTableType('B', 'F', 'S');
10
11 result :=
12 myTable1 SUBMULTISET OF myTable2;
13 IF result THEN
14 DBMS_OUTPUT.PUT_LINE('myTable1 subset of myTable2');
15 END IF;
16 END submultiset_example;
17 /
Procedure created.
SQL> CALL submultiset_example();
Call completed.
SQL>