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

How To Know oracle table information

sahmed ahmed

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

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

Good Luck,
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


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

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

I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: How To Know oracle table information
It's not a secret anymore!