Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Table function with varray column

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> INSERT INTO address_list VALUES('OFF101',numberVarryType(1001,1002,1003,1004)); 1 row created. 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> drop table address_list; Table dropped.