SUBMULTISET operator checks whether a VARRAY or NESTED TABLE collection is a subset of a mirrored datatype : SUBMULTISET « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. SUBMULTISET

SQL>
SQL>  DECLARE
  2     TYPE list IS TABLE OF INTEGER;
  3     a LIST := list(1,2,3);
  4     b LIST := list(1,2,3,4);
  5   BEGIN
  6     IF a SUBMULTISET b THEN
  7       dbms_output.put_line('Subset.');
  8     END IF;
  9   END;
 10   /
Subset.

PL/SQL procedure successfully completed.