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

List tables and views from object_table

   <source lang="sql">

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