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

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.)