Managing Types |
 Previous |
 Next |
A type is a user-specified object or collection definition. Oracle Database Express Edition (Oracle Database XE) currently only supports collection definitions. There are two categories of Oracle collections (SQL collections):
-
Variable-length arrays (
VARRAYtypes) -
Nested tables (
TABLEtypes)
VARRAY types are used for one-dimensional arrays, while nested table types are used for single-column tables within an outer table.
Topics:
|
See Also: Oracle Database Concepts and Oracle Database PL/SQL User's Guide and Reference for information about collection types |