Oracle PL/SQL/System Tables Views/dba object tables

Query dba_object_tables

 
SQL>
SQL> set verify off
SQL> set linesize 82
SQL> set pagesize 9999
SQL> set feedback on
SQL>
SQL> Prompt Object Tables
Object Tables
SQL>
SQL> column tablespace_name format a16 heading "Tablespace Name"
SQL> column table_name      format a25 heading "Table Name"
SQL> column type_name       format a30 heading "Type Name"
SQL>
SQL> select tablespace_name, table_name,
  2         table_type_owner || "." || table_type type_name
  3    from dba_object_tables
  4   where owner = USER
  5   order by tablespace_name, table_name
  6  /
Tablespace Name  Table Name                Type Name
---------------- ------------------------- ------------------------------
SYSTEM           EMPS_NT                   sqle.EMP_TYPE
1 row selected.
SQL>
SQL>
SQL> --