aspose file tools
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
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: 1135

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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How To Know oracle table information