Find out the names of the tables you own : user_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. user_tables
SQL>
SQL> --USER_TABLES is a view in the Oracle data dictionary.
SQL>
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>








30.105.user_tables
30.105.1.Find out the names of the tables you own
30.105.2.Getting Information on Tables
30.105.3.Getting a list of your own tables
30.105.4.Create disable trigger command by querying user_triggers table
30.105.5.Query user_tables for a table name