ALL_COLL_TYPES describes all named collection types (varrays and nested tables) accessible to the current user.
DBA_COLL_TYPES describes all named collection types in the database.
USER_COLL_TYPES describes all named collection types owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the collection |
TYPE_NAME |
VARCHAR2(30) |
NOT NULL |
Name of the collection |
COLL_TYPE |
VARCHAR2(30) |
NOT NULL |
Description of the collection, such as VARYING ARRAY, [nested] TABLE |
UPPER_BOUND |
NUMBER |
For varrays only, maximum size | |
ELEM_TYPE_MOD |
VARCHAR2(7) |
Type modifier of the element | |
ELEM_TYPE_OWNER |
VARCHAR2(30) |
Owner of the type upon which the collection is based. This value is useful primarily in the case of a user-defined type. | |
ELEM_TYPE_NAME |
VARCHAR2(30) |
Name of the datatype or user-defined type upon which the collection is based | |
LENGTH |
NUMBER |
Length of CHAR elements or maximum length of VARCHAR or VARCHAR2 elements |
|
PRECISION |
NUMBER |
Decimal precision of NUMBER or DECIMAL elements; binary precision of FLOAT elements |
|
SCALE |
NUMBER |
Scale of NUMBER or DECIMAL elements |
|
CHARACTER_SET_NAME |
VARCHAR2(44) |
Name of the character set (CHAR_CS | NCHAR_CS) |
|
ELEM_STORAGE |
VARCHAR2(7) |
Obsolete column | |
NULLS_STORED |
VARCHAR2(3) |
Obsolete column |