Oracle nested table and varrays

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.
What are constraints?
What are constraints?...
Define referential integrity
Define referential integrity - Referential integrity in Oracle is used to establish relationships between tables through foreign keys......
Differences between char and varchar2 data types
The char data type accepts strings that are of fixed length.....
Post your comment