Oracle PL/SQL Tutorial/System Tables Data Dictionary/object table

List tables and views from 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>