Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
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
.
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.
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.