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
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
Explain how to close periods in ar. : oracle accounts receivable
which one is currently in used software cmpanies.
Is there any link between pr form(purchse requisition)and po form(purchase order)
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?
What view would you use to determine free space in a tablespace?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Could you please let me know the interfaces in OM / FA??
default triggers available for reports
How to clone the database using RMAN back
What are different types of transactions in ar? : oracle accounts receivable
Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable