ALL_VARRAYS describes all varrays accessible to the current user.
DBA_VARRAYS describes all varrays in the database.
USER_VARRAYS describes all varrays owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the table containing the varray | |
PARENT_TABLE_NAME |
VARCHAR2(30) |
Name of the containing table | |
PARENT_TABLE_COLUMN |
VARCHAR2(4000) |
Name of the varray column or attribute | |
TYPE_OWNER |
VARCHAR2(30) |
Owner of the varray type | |
TYPE_NAME |
VARCHAR2(30) |
Name of the varray type | |
LOB_NAME |
VARCHAR2(30) |
Name of the LOB if the varray is stored in a LOB | |
STORAGE_SPEC |
VARCHAR2(30) |
DEFAULT value indicates that the storage was defaulted. USER_SPECIFIED value indicates that the storage was 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) |