SEARCH

 

CARDINALITY 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;

Add your comments or share tips on Cardinality

 

Top

 
   Copyright © 2002-2008 OracleHome.co.uk All rights are reserved.