SUBMULTISET

The SUBMULTISET condition tests whether a specified nested table is a submultiset of another specified nested table. The operator returns a boolean value: TRUE if nested_table1 is a submultiset of nested_table2.

submultiset_conditions::=

Description of the illustration submultiset_conditions.gif

• The OF keyword is optional and does not change the behavior of the operator.

• The NOT keyword reverses the boolean output: Oracle returns FALSE if nested_table1 is a subset of nested_table2.

• The element types of the nested table must be comparable. Please refer to "Comparison Conditions " for information on the comparability of nonscalar types.

Example

The following example selects from the customers_demo table those rows in which the cust_address_ntab nested table is a submultiset of the cust_address2_ntab nested table:

SELECT customer_id, cust_address_ntab
  FROM customers_demo
  WHERE cust_address_ntab SUBMULTISET OF cust_address2_ntab;

no rows selected

The preceding example requires the table customers_demo and two nested table columns containing data. Please refer to "Multiset Operators " to create this table and nested table columns.