aspose file tools*
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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: 1129

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