This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes How To Know oracle table information Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "How To Know oracle table information" Watch "How To Know oracle table information" New topic
Author

How To Know oracle table information

sahmed ahmed
Greenhorn

Joined: Sep 14, 2005
Posts: 3
How To Know oracle table information like the constraints on table.
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1134

Sahmed,
You can either directly query the Oracle data dictionary, or you can use the "java.sql.DatabaseMetaData" class.

Good Luck,
Avi.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

If you want to get info by using query then you can execute query on user_constraints


Shailesh


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Rajendra Pachouri
Greenhorn

Joined: Sep 16, 2005
Posts: 10
By using Metadata u can do it.


123
 
GeeCON Prague 2014
 
subject: How To Know oracle table information