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) |
|
Whether the collection |
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] |