Query dba_object_tables : dba_object_tables « System Tables Views « Oracle PL / SQL






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                   JAVA2S.EMP_TYPE

1 row selected.

SQL>
SQL>

SQL> --

 








Related examples in the same category