Nested tables - Definition,Features - PL/SQL

Q.  Nested tables are a good choice when -

- Published on 26 Jun 15

a. The index values are not consecutive.
b. There is no set number of index values. However, a maximum limit is imposed.
c. You need to delete or update some elements, but not all the elements at once.
d. You would usually create a separate lookup table, with multiple entries for each row of the main table, and access it through join queries.
e. All mentioned above

ANSWER: All mentioned above
A nested table is similar to index by table but it can be stored in the database columns. It can be considered as a single column table that can either be in a memory or as a column in a database table. The elements can be deleted or added anywhere in a nested table. It may even contain empty elements.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)