Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_TYPE_ATTRS

Description of attributes of types accessible to the user

Columns
   ___________________________
 
   CHARACTER_SET_NAME
      Character set name of the attribute
   ATTR_NAME
      Name of the attribute
   TYPE_NAME
      Name of the type
   OWNER
      Owner of the type
   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 VARCHAR or VARCHAR2 attribute
   ATTR_NO
      Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number)
   ATTR_TYPE_MOD
      Type modifier of the attribute
   SCALE
      Scale of the NUMBER or DECIMAL attribute
   PRECISION
      Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute

Related Commands:




Back to the Top

Simon Sheppard
SS64.com