Skip Headers

Oracle® Database SQL Reference
10g Release 1 (10.1)

Part Number B10759-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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 submultiset_conditions.gif follows
Description of the illustration submultiset_conditions.gif


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.