Using a Varray Type to Define a Column


CREATE TYPE t_varray AS VARRAY(3) OF VARCHAR2(50);
/

SQL> CREATE TABLE emp(
  2      id INTEGER PRIMARY KEY,
  3      first_name VARCHAR2(10),
  4      last_name VARCHAR2(10),
  5      addresses t_varray
  6  );

Table created.

SQL>
Home »
Oracle »
PL/SQL » 

Varrays:
  1. Creating a Varray Type
  2. Using a Varray Type to Define a Column
  3. Getting Information on a Varray
  4. Populating a Varray with Elements
  5. Retrieving Elements from a Varray
  6. Using TABLE() to Treat a VArrays
  7. Modifying Elements of a Varray
Related: