Information about tables in database.

Hello all,
I am a newbie in using ORACLE. I have used MySQL sometimes. While using MySQL i have used "SHOW TABLES" to know about the tables, but this command does not work in case of ORACLE. What is counterpart command of "SHOW TABLES" in ORACLE.
Please Help Me,

Suyash.Upadhyay

re: Information about tables in database.

In case of sql tou may give the show table command but when it comes to oracle you must use.,

SELECT * FROM TAB;

- this shows the list of all the tables(only tables) in the corresponding user


SELECT * FROM CAT;

This shows all the objects such as tables,synonyms,clusters etc..


Have a nice day..

regards
hsivas

re: Information about tables in database.

If u want to know the structure of the table use,

DESC <tablename>

example:

desc emp

This shows the structure of the emp table. If u want to view the datas in table use

Select * from <tablename>;

regards
hsivas

re: Information about tables in database.

Thanx hsivas,
your first reply was really helpful for me.
Thank you very much

re: Information about tables in database.

How can I calculate the size of a table using oracle 10g.

All the best