SQL Functions: CARDINALITY

CARDINALITY:

Returns the number of elements in a nested table column. Returns NULL if the table is empty.

Select emp, CARDINALITY (COL) FROM emp;

This will give the number of elements in the nested table column COL