ALL_VARRAYS

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	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`)