Cardinality – Oracle SQL Function

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;