What table/view do you query against to select all the table names in a schema in Oracle?

Question

What object do you query against to select all the table names in a schema in Oracle?

Answer 1

You may use,

select tabname from tabs

to get the name of tables present in schema.

Answer 2

you're looking for:

select table_name from user_tables;

Answer 3

To see all the tables you have access to

select table_name from all_tables where owner='<SCHEMA>';

To select all tables for the current logged in schema (eg, your tables)

select table_name from user_tables;