A type is a user-specified object or collection definition. Oracle Application Express currently only supports collection definitions. There are two categories of Oracle collections (SQL collections):
Variable-length arrays (VARRAY
types)
Nested tables (TABLE
types)
VARRAY
types are used for one-dimensional arrays, while nested table types are used for single-column tables within an outer table.
Topics:
Oracle Database Concepts and Oracle Database PL/SQL Language Reference for information about collection types
To create a collection type:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
Click Create.
From the list of object types, select Type.
Specify a name and click Next.
Select a type, data type, limit, and click Next.
A confirmation page appears, which displays the SQL used to create the type.
Click Create Type.
To browse a collection type:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
From the Object list, select Types.
From the Object Selection pane, select a type.
The Object Details view appears.
Click the tabs at the top of the page to view different reports. Table 1-6 describes all available views.
Table 1-6 Available Views for Types
To drop a collection type:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
From the Object list, select Types.
From the Object Selection pane, select a type.
The Object Details view appears.
Click Drop.
To confirm, click Finish.