DBA_COLL_TYPES

Description of all named collection types in the database

Columns
   ___________________________
 
   OWNER
      Owner of the type
   TYPE_NAME
      Name of the type
   COLL_TYPE
      Collection type
   UPPER_BOUND
      Size of the FIXED ARRAY type or maximum size of the VARYING ARRAY type
   ELEM_TYPE_MOD
      Type modifier of the element
   ELEM_TYPE_OWNER
      Owner of the type of the element
   ELEM_TYPE_NAME
      Name of the type of the element
   LENGTH
      Length of the CHAR element or maximum length of the VARCHARor VARCHAR2 element
   PRECISION
      Decimal precision of the NUMBER or DECIMAL element orbinary precision of the FLOAT element
   SCALE
      Scale of the NUMBER or DECIMAL element
   CHARACTER_SET_NAME
      Character set name of the element
   ELEM_STORAGE
      Storage optimization specification for VARRAY of numeric elements
   NULLS_STORED
      Is null information stored with each VARRAY element?

Related:

Simon Sheppard
SS64.com