Table function with varray column : table function « Object Oriented « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Object Oriented
3. table function

SQL>
SQL> CREATE OR REPLACE TYPE numberVarryType AS VARRAY(10)OF NUMBER(10);
  2  /

Type created.

SQL>
SQL> CREATE TABLE address_list (
  2      list_id VARCHAR2(6)PRIMARY KEY,
  3      direct_addresses numberVarryType
  4  );

Table created.

SQL>
SQL>
SQL> INSERT INTO address_list VALUES('OFF101',numberVarryType(1001,1002,1003,1004));

1 row created.

SQL>
SQL>
SQL> SELECT list_id,column_value FROM address_list,TABLE(direct_addresses);

LIST_I COLUMN_VALUE
------ ------------
OFF101         1001
OFF101         1002
OFF101         1003
OFF101         1004

4 rows selected.

SQL>
SQL>
SQL> drop table address_list;

Table dropped.