DBA_TYPE_ATTRS

Description of attributes of all types in the database

Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Owner of the type
TYPE_NAME VARCHAR2 (30) Yes Name of the type
ATTR_NAME VARCHAR2 (30) Yes Name of the attribute
ATTR_TYPE_MOD VARCHAR2 (7)
Type modifier of the attribute
ATTR_TYPE_OWNER VARCHAR2 (30)
Owner of the type of the attribute
ATTR_TYPE_NAME VARCHAR2 (30)
Name of the type of the attribute
LENGTH NUMBER

Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION NUMBER

Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE NUMBER

Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the attribute
ATTR_NO NUMBER
Yes 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)
INHERITED VARCHAR2 (3)
Is the attribute inherited from the supertype ?

Usage:


  cursor cur_attribute(c_name in dba_types.type_name%type
                     , c_owner in dba_types.owner%type) is
  SELECT OWNER
  ,      TYPE_NAME
  ,      ATTR_NAME
  ,      ATTR_TYPE_MOD
  ,      ATTR_TYPE_OWNER
  ,      ATTR_TYPE_NAME
  ,      LENGTH
  ,      PRECISION
  ,      SCALE
  ,      CHARACTER_SET_NAME
  ,      ATTR_NO
  FROM SYS.DBA_TYPE_ATTRS
  where owner = c_owner
  and type_name = c_name
  order by attr_no;