Query user_tables for a table name : user_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL>
SQL> select table_name from user_tables where table_name like '%REGION1';

no 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