You create a nested table type using the CREATE TYPE statement:
If you don't specify the maximum size of a nested table, you can insert any number of elements in a nested table.
SQL> CREATE Or Replace TYPE AddressType AS OBJECT ( 2 street VARCHAR2(15), 3 city VARCHAR2(15), 4 state CHAR(2), 5 zip VARCHAR2(5) 6 ); 7 / SQL> SQL> CREATE Or Replace TYPE nested_table_AddressType AS TABLE OF AddressType; 2 / Type created.