DBA_TYPE_ATTRS

Description of attributes of all types in the database

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

Related Commands:

Simon Sheppard
SS64.com