Getting a list of your own tables : 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>
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>
SQL>
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