pl/sql

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

A.J - 31 May 2005 09:47 GMT

I am using a database named contacts.Now i want to see all the tables
within the database.What query am i suppose to fire?

Reply to this Message

Rauf Sarwar - 31 May 2005 09:54 GMT

> I am using a database named contacts.Now i want to see all the tables
> within the database.What query am i suppose to fire?

Goto http://tahiti.oracle.com and lookup usage for ALL/USER/DBA_TABLES
views.

Regards
/Rauf

Reply to this Message

A.J - 31 May 2005 10:16 GMT

thanks a lot but i am Unable to find the desired answer.Could you
please tell me the exact query for viewing all the tables within the
database.

Reply to this Message

Rauf Sarwar - 31 May 2005 12:18 GMT

> thanks a lot but i am Unable to find the desired answer.Could you
> please tell me the exact query for viewing all the tables within the
> database.

In that case... disregard my post.

Start by learning the SQL (Structured Query Language) first. You should
be able to find SQL Reference guide at the provided link or search thru
Amazon website for a good book.

Regards
/Rauf

Reply to this Message

A.J - 31 May 2005 12:22 GMT

Okay.I will do that. Thanks a lot for helping me.

Reply to this Message

tina london - 31 May 2005 10:38 GMT

> I am using a database named contacts.Now i want to see all the tables
> within the database.What query am i suppose to fire?

connect as a dba and issue select table_name from dba_tables

Reply to this Message

A.J - 31 May 2005 11:03 GMT

Thankx a lot.

Reply to this Message

Tom Dyess - 31 May 2005 13:36 GMT

> Thankx a lot.

You could also use

Select table_name from user_tables for just the user's tables.

Signature

Tom Dyess
OraclePower.com

Reply to this Message