This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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


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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: How To Know oracle table information
 
It's not a secret anymore!