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> UPDATE address_list
2 SET direct_addresses =numberVarryType(1011,1012,1013)
3 WHERE list_id ='OFF102';
0 rows updated.
SQL>
SQL> drop table address_list;
Table dropped.