Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query user_tables for a table name

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