What is the Oracle equivalent of 'show tables' in MySQL

Question

There is all kinds of advice out there on the net as to how to see all the tables in an oracle database. I am very new to Oracle but if I create a 'database' which is known as an 'instance' in Oracle parlance, how would I find all the tables belonging just to that one instance as opposed to all of Oracle?

Thanks

Answer 1

select *
from dba_tables

(Note that typically only the DBA role has access to that view).

If you actually want to see only the tables that are owned by the current user (not "the instance), use

select *
from user_tables;

To see the tables accessible by the current user, use:

select *
from_all_tables;

For more details, see the manual:

• DBA_TABLES
• USER_TABLES
• ALL_TABLES