Oracle8i and higher supports the following collection data types:
VARRAY
TABLE
OBJECT
The examples in this section are based on the following Create Table and data type definitions:
CREATE TYPE num_varray AS VARRAY(4) OF NUMBER(12,2) CREATE TYPE num_table AS TABLE of NUMBER(12,2) CREATE TYPE city_object as OBJECT ( Name VARCHAR2(40), Province VARCHAR2(40), City_Code VARCHAR2(10), Population Number) CREATE TABLE complex_type_table (array_col num_varray, table_col num_table, object_col city_object) NESTED TABLE TABLE_COL STORE AS TABLE_COL_NT