Query dba_type_attributes table : dba_type_attributes « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_type_attributes

Query dba_type_attributes table

 
SQL>
SQL>
SQL> column type format a30
SQL>
SQL>  select attr_name,
  2             decode( attr_type_owner, null, null, attr_type_owner || '.' ) ||
  3             attr_type_name ||
  4             decode( attr_type_name,
  5                     'VARCHAR2', '('||length||')',
  6                     'CHAR', '('||length||')',
  7                     'NUMBER', '('||precision||','||scale||')',
  8                     null ) type
  9        from dba_type_attrs
 10      where owner = 'OE' and type_name = 'COMPOSITE_CATEGORY_TYP'
 11      order by attr_no
 12     /

no rows selected

SQL> --

 

Related examples in the same category