Nested tables - Definition,Features - PL/SQL
Q. Nested tables are a good choice when -
(PL/SQL)- Published on 26 Jun 15a. 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.
