|
SQL>
SQL> CREATE OR REPLACE TYPE numberTableType AS TABLE OF NUMBER(10);
2 /
Type created.
SQL> CREATE TABLE address_list (list_id VARCHAR2(6)PRIMARY KEY,
2 home_addresses numberTableType )
3 NESTED TABLE home_addresses STORE AS home_addreses_tab;
SQL>
SQL>
SQL> INSERT INTO address_list VALUES ('H101',numberTableType(1001,1002,1003,1004));
SQL>
SQL>
SQL> DECLARE
2 v_numberVarryType numberTableType :=numberTableType(2001,2002);
3 BEGIN
4 INSERT INTO address_list VALUES ('H102',v_numberVarryType);
5 END;
6 /
SQL>
SQL> drop table address_list;
|