ALL_VARRAYS
ALL_VARRAYS describes the varrays accessible to the current user.
Related Views
-
DBA_VARRAYSdescribes all varrays in the database. -
USER_VARRAYSdescribes the varrays owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(128) |
Owner of the table containing the varray | |
PARENT_TABLE_NAME |
VARCHAR2(128) |
Name of the containing table | |
PARENT_TABLE_COLUMN |
VARCHAR2(4000) |
Name of the varray column or attribute | |
TYPE_OWNER |
VARCHAR2(128) |
Owner of the varray type | |
TYPE_NAME |
VARCHAR2(128) |
Name of the varray type | |
LOB_NAME |
VARCHAR2(128) |
Name of the LOB if the varray is stored in a LOB | |
STORAGE_SPEC |
VARCHAR2(30) |
Indicates whether the storage was defaulted (DEFAULT) or user-specified (USER_SPECIFIED) |
|
RETURN_TYPE |
VARCHAR2(20) |
Return type of the column:
|
|
ELEMENT_SUBSTITUTABLE |
VARCHAR2(25) |
Indicates whether the varray element is substitutable (Y) or not (N) |
See Also: