Static Data Dictionary Views, 12 of 452

ALL_COLL_TYPES

ALL_COLL_TYPES describes all named collection types (varrays and nested tables) accessible to the user.

USER_COLL_TYPES describes all named collection types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the collection
`TYPE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the collection
`COLL_TYPE`	`VARCHAR2(30)`	`NOT NULL`	Description of the collection, such as VARYING ARRAY, [nested] TABLE
`UPPER_BOUND`	`NUMBER`		For varrays only, maximum size
`ELEM_TYPE_MOD`	`VARCHAR2(7)`		Whether the collection
`ELEM_TYPE_OWNER`	`VARCHAR2(30)`		Owner of the type upon which the collection is based. This value is useful primarily in the case of a user-defined type.
`ELEM_TYPE_NAME`	`VARCHAR2(30)`		Name of the datatype or user-defined type upon which the collection is based
`LENGTH`	`NUMBER`		Length of CHAR elements or maximum length of VARCHAR or VARCHAR2 elements
`PRECISION`	`NUMBER`		Decimal precision of NUMBER or DECIMAL elements; binary precision of FLOAT elements
`SCALE`	`NUMBER`		Scale of NUMBER or DECIMAL elements
`CHARACTER_SET_NAME`	`VARCHAR2(44)`		Name of the character set (CHAR_CS \| NCHAR_CS)
`ELEM_STORAGE`	`VARCHAR2(7)`		[Obsolete column]
`NULLS_STORED`	`VARCHAR2(3)`		[Obsolete column]