Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Getting a list of your own tables

SQL> SQL> SELECT table_name FROM user_tables where rownum < 50; TABLE_NAME ------------------------------ HAZARD_LEVEL_T PUBLICATION DDL_AUDIT SITE_TAB HOME_ADDRESS_LIST HOME_ADDRESES_TAB I1 T1_TIMES I2 MAP AVAIL_TRACE_FILES PARTS LOG_TABLE DUMMY WORKING_CUSTOMERS OUTRAIN INTEREST TEST_BFILE P 19 rows selected. SQL>