Question For Collections

PL/SQL Interview Question  for Collections.

What is Collection? How many type of collection?
Why or when we will use collection?
What is the difference between PL/SQL table, Nested table and Varrays ?
What are common exception related with collection?
What are common methods of handling exceptions?
Give sample defination of varray of object and table of object?
What is the difference between Collection and Record?
What is inline storage and out of line stogare of the nested table?
Write a program using collections.
at
Labels:

DBMS_XPLAN

One more way we can see the Explain Plan by using DBMS_XPLAN package. DBMS_XPLAN automatically queries the last plan in PLAN_TABLE. It u...

  • Collection In PL/SQL
    An Oracle PL/SQL collection is a single-dimensional array; it consists of one or more elements accessible through an index value. Collectio...
  • Difference Between Collection and Record
    What is the difference between Collection and Records? Collection Record The internal components always have the same data type, ...
  • Question For Collections
    PL/SQL Interview Question  for Collections. What is Collection? How many type of collection? Why or when we will use collection? What i...