The following will give you information on all tables:


Many of those of course will be system tables, not application tables.
And depending on the user you are, you may not be able to execute the query (you may not have the privileges) and may not be able to access all tables you get returned.

type this command
SELECT * FROM ALL_TABLES . this will enable to view all the tables that yuou have created and the one you granted provilege to view.

If you are just interested in viewing the names and not the other info about tables, you can use

try this:

select TABLE_NAME from USERS_TABLES;
good luck (Y)

select * from Tab;

select * from tab