3.7 Managing Types
A type is a user-specified object or collection definition. Use Object Browser to create, view, or drop a type.
Oracle APEX 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.
- Creating a Type
Create a type using Object Browser. - Viewing a Type
Select a type from the Object Tree and access tabs in the Object Detail View. - Dropping a Type
Select a type from the Object Tree pane and click Drop on the Object Details tab.
See Also:
-
Oracle Database PL/SQL Language Reference and for information about collection types
Parent topic: Managing Database Objects with Object Browser
3.7.1 Creating a Type
Create a type using Object Browser.
To create a collection type:
Parent topic: Managing Types
3.7.2 Viewing a Type
Select a type from the Object Tree and access tabs in the Object Detail View.
To browse a collection type:
- In Object Browser, Object Tree, expand Types and select a type to view.
- The Object Detail View appears and displays four tabs:
- Object Details - Displays details
about the selected type. Available actions include:
- Drop.
- Refresh
- Synonyms - Displays a list of synonyms for the current type. Available actions include:Refresh.
- Grants - Displays a list of grants
associated with the type. Grant details include grantee, privilege, and
grant options. Available actions include:
- Grant
- Revoke
- Refresh
- DDL - Displays the DDL necessary to re-create this type. Available actions include:
- Download.
- Refresh
- Object Details - Displays details
about the selected type. Available actions include:
Parent topic: Managing Types
3.7.3 Dropping a Type
Select a type from the Object Tree pane and click Drop on the Object Details tab.
To drop a collection type:
Parent topic: Managing Types