ALL_COLL_TYPES

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

Related Views

• DBA_COLL_TYPES describes all named collection types in the database.
• 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]