Oracle PL/SQL/System Tables Views/dba types

Query dba_types table

   <source lang="sql">

SQL> SQL> column name format a25 SQL> column extends format a29 SQL> column "# ATTRS" format a7 SQL> column "# METHS" format a7 SQL> select type_name name,

 2             decode( supertype_owner, null, null,
 3                     supertype_owner || "." || supertype_name ) "EXTENDS",
 4             final,
 5             attributes "# ATTRIBUTES",
 6             methods "# METHODS"
 7        from dba_types
 8       where owner = upper( "OE" )
 9      /

no rows selected SQL> SQL> --

</source>