SQL>
SQL> CREATE OR REPLACE TYPE numberTableType AS TABLE OF NUMBER(10);
2 /
Type created.
SQL>
SQL> CREATE TABLE address_list (
2 list_id VARCHAR2(6)PRIMARY KEY,
3 home_addresses numberTableType )
4 NESTED TABLE home_addresses STORE AS home_addreses_tab;
SQL>
SQL> drop table address_list;
SQL>