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

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

SUBMULTISET operator checks whether a VARRAY or NESTED TABLE collection is a subset of a mirrored datatype

 

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.

   
  

Related examples in the same category