Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TYPE_ATTRS

Description of attributes of the user's own types

Columns
   ___________________________
 
   PRECISION
      Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
   ATTR_NAME
      Name of the 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)
   SCALE
      Scale of the NUMBER or DECIMAL attribute
   LENGTH
      Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
   ATTR_TYPE_OWNER
      Owner of the type of the attribute
   TYPE_NAME
      Name of the type
   ATTR_TYPE_MOD
      Type modifier of the attribute
   CHARACTER_SET_NAME
      Character set name of the attribute
   ATTR_TYPE_NAME
      Name of the type of the attribute

Related Commands:




Back to the Top

Simon Sheppard
SS64.com