How to get list of all tables in Oracle?

Get list of tables in Oracle using user_tables

You can get the list of all tables in an Oracle database by executing the following SQL statement:

SELECT table_name FROM user_tables;

This will return the list of all tables owned by the current user.

If you want to see the tables in all schemas, you can use the following SQL statement:

SELECT owner, table_name FROM all_tables;