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 are different types of receipt reversals ? Explain them : oracle accounts receivable
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?
where the dff data will be stored
which one is currently in used software cmpanies.
what is the link between suppliers and banks in ap module in oracle apps? And also query?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
What is the difference between recovery and restoring of the oracle database?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
default triggers available for reports
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
How would you go about increasing the buffer cache hit ratio?
What is autocashrule set? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
