Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Populating a Varray with Elements

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>