|
|
|
| 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?
| |
| Rauf Sarwar 2005-05-31, 7:23 am |
|
A.J wrote:
> 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
| |
|
| 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.
| |
| tina london 2005-05-31, 7:23 am |
|
"A.J" <ajay.bisht@gmail.com> wrote in message
news:1117529271.192879.245800@z14g2000cwz.googlegroups.com...
> 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
| |
|
|
| Rauf Sarwar 2005-05-31, 7:23 am |
|
A.J wrote:
> 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
| |
|
| Okay.I will do that. Thanks a lot for helping me.
| |
| Tom Dyess 2005-05-31, 7:23 am |
| "A.J" <ajay.bisht@gmail.com> wrote in message
news:1117533788.039908.11460@g49g2000cwa.googlegroups.com...
> Thankx a lot.
>
You could also use
Select table_name from user_tables for just the user's tables.
--
Tom Dyess
OraclePower.com
|
|
|
|