2.7 Managing Types
A type is a user-specified object or collection definition. You can create, browse, drop a type and view a report.
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.
- Creating a Type
Create a type using Object Browser. - Browsing a Type
Select a type from the Object Selection pane and view different reports for the type. - Reports for Types
Alternative views available when viewing a type in Object Browser. - Dropping a Type
Select a type from the Object Selection pane and click Drop.
See Also:
-
"Oracle Database PL/SQL Language Reference" and for information about collection types
Parent topic: Managing Database Objects with Object Browser
2.7.1 Creating a Type
Create a type using Object Browser.
To create a collection type:
Parent topic: Managing Types
2.7.2 Browsing a Type
Select a type from the Object Selection pane and view different reports for the type.
To browse a collection type:
Parent topic: Managing Types
2.7.3 Reports for Types
Alternative views available when viewing a type in Object Browser.
Table 2-6 describes all available reports for types.
Table 2-6 Available Reports for Types
Parent topic: Managing Types
2.7.4 Dropping a Type
Select a type from the Object Selection pane and click Drop.
To drop a collection type:
Parent topic: Managing Types