How can i view tables in the databse

[topsege2007]

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)

[jwenting]

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.

[topsege2007]

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.

[iceman29]

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

select * from tab

[yisus]

try this:

select TABLE_NAME from USERS_TABLES;
good luck (Y)

[sugat]

select * from Tab;

[tsfahmad360]

select * from tab