Creating a Nested Table Type

A nested table stores an unordered set of elements. Its supported operations are insert, update, and delete. A nested table doesn't have a maximum size.


CREATE TYPE t_address AS OBJECT (
    street VARCHAR2(15),
    city VARCHAR2(15),
    state CHAR(2),
    zip VARCHAR2(5)
);
/

CREATE TYPE t_nested_table AS TABLE OF t_address;
/
Home »
Oracle »
PL/SQL » 

Nested Table:
  1. Creating a Nested Table Type
  2. Using a Nested Table Type to Define a Column
  3. Get Information on Nested Table
  4. Populating a Nested Table with Elements
  5. Retrieving Elements from a Nested Table
  6. Using TABLE() with a Nested Table
Related: