How to view all tables in an Oracle database

 

If you want to query all the tables in the database, you can query
Select * From dba_tables

If you want to query the tables of a user in the database, you can also log on to the user and then query:
Select * From user_tables

 

To import External SQL statements, run the following command:

SQL> @ E: file name. SQL

 

If you want to save the results of the select * From tablename; statement, you can do this in SQL * Plus:

Spool C: test. SQL // This is the location where the file is saved
Select * From tablename;
Spool off