cardinality sql

CARDINALITY returns the number of records in a nested table. The function returns a NUMBER result. Example: SELECT ID,NAME,CARDINALITY(some_nested_table) FROM TABLE_NAME;