Like the DESCRIBE statement used to view columns in a given table, What SQL statement can i use to view the tables in a database. (Oracle 10g)

The following will give you information on all tables:

select * from sys.ALL_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

select * from tab

try this:

select TABLE_NAME from USERS_TABLES;
good luck (Y)

commented: zombie master -3

select * from Tab;

commented: don't regurgitate old answers to reopen zombies -3

select * from tab

commented: don't regurgitate old answers to reopen zombies -3
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.