Nested tables - Definition,Features, Advantages - PL/SQL Collections and Records
Q. Nested tables are a good choice when- Published on 07 Jul 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