Collections Oracle PLSQL Tutorial

You can populate the elements in a varray using an INSERT statement.

SQL>
SQL> CREATE Or Replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50);
  2  /
Type created.
SQL> CREATE TABLE employee (
  2    id         INTEGER PRIMARY KEY,
  3    first_name VARCHAR2(10),
  4    last_name  VARCHAR2(10),
  5    addresses  addressVarray
  6  );
Table created.
SQL>
SQL> DESCRIBE employee;
 Name            Null?    Type
 ID              NOT NULL NUMBER(38)
 FIRST_NAME               VARCHAR2(10)
 LAST_NAME                VARCHAR2(10)
 ADDRESSES                ADDRESSVARRAY
SQL>
SQL> INSERT INTO employee VALUES (
  2    1, 'Steve', 'Brown',
  3    addressVarray(
  4      'AAAAAAAAAAAAAAAA',
  5      'BBBBBBBBBBBBBBBB'
  6    )
  7  );
1 row created.
SQL>
SQL> SELECT *
  2  FROM employee;
ID FIRST_NAME LAST_NAME           ADDRESSES
----------------------------------------------------------------------------------------
1 Steve      Brown                ADDRESSVARRAY('AAAAAAAAAAAAAAAA', 'BBBBBBBBBBBBBBBB')
SQL>
SQL> drop table employee;
Table dropped.
SQL>