Monday, 13 August 2012

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