List tables and views from object_table : object_table « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. object_table

SQL>
SQL> select object_name, object_type
  2  from   obj
  3  where  object_type in ('TABLE','VIEW')
  4         and rownum < 50
  5  order  by object_type, object_name;

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
AVAIL_TRACE_FILES
TABLE

DDL_AUDIT
TABLE

DUMMY
TABLE

HAZARD_LEVEL_T
TABLE

HOME_ADDRESES_TAB
TABLE

HOME_ADDRESS_LIST
TABLE

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------

I1
TABLE

I2
TABLE

INTEREST
TABLE

LOG_TABLE
TABLE

MAP
TABLE

OUTRAIN

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
TABLE

P
TABLE

PARTS
TABLE

PUBLICATION
TABLE

SITE_TAB
TABLE

T1_TIMES
TABLE


OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
TEST_BFILE
TABLE

WORKING_CUSTOMERS
TABLE

APPLICATION_USERS
VIEW

AUTHOR_PUBLICATION
VIEW

AVG_EVALUATIONS
VIEW

COURSE_DAYS
VIEW

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------

CRS_COURSE_SCHEDULE
VIEW

CRS_OFFERINGS
VIEW

DEPT20_V
VIEW

DEPT_OR
VIEW

EMP_V
VIEW

EMP_VIEW

OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_TYPE
-------------------
VIEW

HRC_ORG_SITE
VIEW

SALES_BY_ATLAS_V
VIEW

SALES_PER_PERSON_V
VIEW

USER_AVAIL_TRACE_FILES
VIEW


33 rows selected.

SQL>