Static Data Dictionary Views, 103 of 452

ALL_VARRAYS

ALL_VARRAYS describes all varrays accessible to the user.

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