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

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

Query dba_types table

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

 

Related examples in the same category