What is cardinality?

Answer Posted / cherie

In Oracle/PLSQL, the cardinality function returns the
number of elements in a nested table.

The syntax for the cardinality function is:

cardinality( nested table column )

nested table column is the column in the nested table that
you wish to return the cardinality for.



Note:

If the nested table is empty, the cardinality function will
return NULL.

If the nested table is a null collection, the cardinality
function will return NULL.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2170


where the dff data will be stored

2038


What are different types of receipt reversals ? Explain them : oracle accounts receivable

998


Could you please let me know the interfaces in OM / FA??

1971


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7218


hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2017


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2246


What is the difference between recovery and restoring of the oracle database?

901


as a technical developer in oracle applications which type errors feced in your experience sofar

2126


1. What is PO rate variance gain and loss?

2557


What is an Oracle database Partial Backup?

941


What are different types of transactions in ar? : oracle accounts receivable

1020


What is auto invoicing? : oracle accounts receivable

878


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

1909


as a technical developer in oracle applications which type errors feced in your experience sofar

2014