• Post Reply Bookmark Topic Watch Topic
  • New Topic

How To Know oracle table information  RSS feed

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How To Know oracle table information like the constraints on table.
 
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sahmed,
You can either directly query the Oracle data dictionary, or you can use the "java.sql.DatabaseMetaData" class.

Good Luck,
Avi.
 
Ranch Hand
Posts: 1084
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want to get info by using query then you can execute query on user_constraints


Shailesh
 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By using Metadata u can do it.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!