Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_COLL_TYPES

Description of the user's own named collection types 

Columns
   ___________________________
 
   TYPE_NAME
      Name of the type USER_COLL_TYPES
   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