ADM_COLL_TYPES

ADM_COLL_TYPES displays information about all collection types. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_COLL_TYPES columns
Name	Type	Description
owner	character varying(128)	Owner of a cluster.
type_name	character varying(128)	Name of a collection.
coll_type	character varying(128)	Description of a set.
upper_bound	numeric	Not supported. Its value is NULL.
elem_type_mod	character varying(7)	Not supported. Its value is NULL.
elem_type_owner	character varying(128)	Owner of the element type on which the collection is based. This parameter is mainly used for user-defined types.
elem_type_name	character varying(128)	Name of the data type or user-defined type on which the collection is based.
length	numeric	Not supported. Its value is NULL.
precision	numeric	Not supported. Its value is NULL.
scale	numeric	Not supported. Its value is NULL.
character_set_name	character varying(44)	Not supported. Its value is NULL.
elem_storage	character varying(7)	Not supported. Its value is NULL.
nulls_stored	character varying(3)	Not supported. Its value is NULL.
char_used	character varying(1)	Not supported. Its value is NULL.