Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
Use the IS
[NOT]
EMPTY
conditions to test whether a specified nested table is empty, regardless whether any elements of the collection are NULL
.
The condition returns a boolean value: TRUE
for an IS
EMPTY
condition if the collection is empty, and TRUE
for an IS
NOT
EMPTY
condition if the collection is not empty. If you specify NULL
for the nested table or varray, the result is NULL
.
The following example selects from the sample table pm.print_media
those rows in which the ad_textdocs_ntab
nested table column is not empty:
SELECT product_id, TO_CHAR(ad_finaltext) FROM print_media WHERE ad_textdocs_ntab IS NOT EMPTY;