You can use the following code to list all the tables in the Oracle database-
sql> SELECT table_name
FROM dba_tables;
In order to get all the table names, you may also use-
Select owner, table_name from all_tables;
This will list only the required data instead of extra data that confuses you.
