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.

can we use lexical perameter in oracle plsql if yes how

1826

---

Difference between negative and positive adjustments : oracle accounts receivable

622

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6739

---

Is there any link between pr form(purchse requisition)and po form(purchase order)

2145

---

Differentiate between unidentified receipt, unapplied receipts and on account receipts? : oracle accounts receivable

1243

---

---

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

716

---

What is auto invoicing? Explain : oracle accounts receivable

616

---

Differentiate between transaction type and transaction source? : oracle accounts receivable

679

---

What is chargeback invoice? How do we create it? : oracle accounts receivable

728

---

how to replace not in with not exist?

3193

---

difference of using cursor for loop and open,fetch,close.which one is better

1254

---

What is db_recovery_file_dest in oracle? When do you need to set this value?

649

---

What is mrc and what is its use? : oracle accounts receivable

631

---

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

659

---

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

670

---