Oracle cheat sheet

Display existing tables in oracle db

Code:

SELECT owner, table_name
  FROM dba_tables

if you need only user tables:  

SELECT table_name
  FROM user_tables