Managing Types

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:

Creating a Type

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.

Browsing a 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.

Summary of Available Views

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

View	Description
Object Details	Displays details about the selected type. To drop a type, click Drop.
Synonyms	Displays a list of synonyms for the current type.
Grants	Displays a list of grants associated with the type. Grant details include grantee, privilege, and grant options. Actions you can perform include Grant and Revoke.
SQL	Displays the SQL necessary to re-create this type.

Dropping a Type

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.