Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

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>