Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Creating a Nested Table Type

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.