Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Find out the names of the tables you own

SQL> SQL> --USER_TABLES is a view in the Oracle data dictionary. SQL> SQL> select table_name from user_tables   2  / TABLE_NAME ------------------------------ EMPLOYEE_TAB EMP_DEPT PEOPLE SESSION_TAB SESS_EVENT TEMP_ALL_OBJECTS TRANSACTION_TAB 7 rows selected. SQL>