| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 | 
 | 
| 
 | View PDF | 
ALL_VARRAYS describes all varrays accessible to the current user.
Related Views
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) | DEFAULTvalue indicates that the storage was defaulted.USER_SPECIFIEDvalue 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) |