Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Selecting Varray Elements

SQL> SQL> CREATE Or Replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50);   2  / Type created. SQL> 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> SELECT addresses   2  FROM employee; ADDRESSES -------------------------------------------------------- ADDRESSVARRAY('AAAAAAAAAAAAAAAA', 'BBBBBBBBBBBBBBBB') SQL> SQL> drop table employee; Table dropped. SQL>