ALL_COLL_TYPES

Description of named collection types accessible to the user

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:


© Copyright SS64.com 1999-2014
Some rights reserved