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
can we use lexical perameter in oracle plsql if yes how
can u give guidance abt packages of plsql
as a technical developer in oracle applications which type errors feced in your experience sofar
which one is currently in used software cmpanies.
what are the API of GL,PO,AP
What is the sql query to find the employee who has Nth maximum salary?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
how to write customizations in po
What is the mandatory setup in cyclecount ?
What are different types of receipt reversals ? Explain them : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f