This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 1138
    
    1

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: 1082

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: How To Know oracle table information
 
It's not a secret anymore!