Search This Blog

Tuesday, November 19, 2013

Get list of all tables in Oracle

Oracle >List of all tables

See all the tables that your account has access


SELECT owner, table_name FROM all_tables

See table that you own


SELECT table_name FROM user_tables