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> --