Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How To Know oracle table information

 
sahmed ahmed
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.
 
Avi Abrami
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.
 
Shailesh Chandra
Ranch Hand
Posts: 1082
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
 
Rajendra Pachouri
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
By using Metadata u can do it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic