Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Syntax
Purpose
CARDINALITY
returns the number of elements in a nested table. The return type is NUMBER
. If the nested table is empty, or is a null collection, then CARDINALITY
returns NULL
.
Examples
The following example shows the number of elements in the nested table column ad_textdocs_ntab
of the sample table pm.print_media
:
SELECT product_id, CARDINALITY(ad_textdocs_ntab) FROM print_media; PRODUCT_ID CARDINALITY(AD_TEXTDOCS_NTAB) ---------- ----------------------------- 3060 3 2056 3 3106 3 2268 3