Query All Tables in Oracle

In case you are searching for a table name but forgotten. You can use below Oracle query to list all the available tables in your Oracle database.

SQL> select OWNER, TABLE_NAME from ALL_TABLES;

OWNER                          TABLE_NAME
------------------------------ ------------------------------
SYS                            HELP
SYS                            SQL$
SYS                            SQL$TEXT
SAPSR3                         PAT05

19918 rows selected.