Populating a Varray with Elements


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

CREATE TABLE emp(
    id INTEGER PRIMARY KEY,
    first_name VARCHAR2(10),
    last_name VARCHAR2(10),
    addresses t_varray
);


SQL> INSERT INTO emp VALUES (1, 'Jason', 'Bond',t_varray('Main Street, small town, CA, 12345',
  2                                                              'Second Street, middle town, CA, 54321'
  3                                                             )
  4  );

1 row 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: