list of tables in an Oracle database

To list the tables in the schema of the current user:

SELECT table_name FROM user_tables;
or
select * from tab ;

List the tables accessible by the user:

SELECT table_name FROM all_tables;  

List all the tables (must be ADMIN):

SELECT table_name FROM dba_tables;