What is nested table? Explain the purpose of nested table.
A nested table is an unordered set of data elements. These data elements are all of the same datatype. It has a single column whose type is either built in or an object type. It is a table stored within the structure of another table.
Example:NESTED TABLE employee STORE AS employee_table
Purpose:Can load the entire nested table into the database as column values. This means that we can store and retrieve nonatomic data in a single column.
