943,923 Members | Top Members by Rank

Ad:
  • Oracle Discussion Thread
  • Marked Solved
  • Views: 3544
  • Oracle RSS
Jul 9th, 2009
0

display list of all tables in database

Expand Post »
Hi
I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database.
And for that i want to display all the tables created in database. As we can dispaly all the columns of a table by using
select * from table_name So. please tell me such a query by which i can display list of all tables exists in my database.
Reputation Points: 10
Solved Threads: 0
Light Poster
cutedipti is offline Offline
45 posts
since Sep 2008
Jul 9th, 2009
0

Re: display list of all tables in database

Hi Dipti,

You can use the below querry to get the table names in your DB:
Oracle Syntax (Toggle Plain Text)
  1. SELECT * FROM tab;
Reputation Points: 10
Solved Threads: 2
Newbie Poster
iceman29 is offline Offline
12 posts
since Feb 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: sdo_migrate error
Next Thread in Oracle Forum Timeline: project help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC