ALL_TYPE_ATTRS

Description of attributes of types accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the type
   TYPE_NAME
      Name of the type
   ATTR_NAME
      Name of the attribute
   ATTR_TYPE_MOD
      Type modifier of the attribute
   ATTR_TYPE_OWNER
      Owner of the type of the attribute
   ATTR_TYPE_NAME
      Name of the type of the attribute
   LENGTH
      Length of the CHAR attribute or maximum length of the VARCHARor VARCHAR2 attribute
   PRECISION
      Decimal precision of the NUMBER or DECIMAL attribute orbinary precision of the FLOAT attribute
   SCALE
      Scale of the NUMBER or DECIMAL attribute
   CHARACTER_SET_NAME
      Character set name of the attribute
   ATTR_NO
      Syntactical order number or position of the attribute as specified in thetype specification or CREATE TYPE statement (not to be used as ID number)
   INHERITED
      Is the attribute inherited from the supertype ?

Related:


© Copyright SS64.com 1999-2014
Some rights reserved