Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TYPE_ATTRS

Description of attributes of the user's own types 

Columns
   ___________________________
 
   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:


Simon Sheppard
 SS64.com