I want some samples of code to fetch all constraints schema name right now i can get table names, number of columns in table, their datatype and name of columns through resultsetmetadeta need code some what like this
Oracle provides a lot of database catalogue views such as ALL_CONSTRAINTS that will give you a vast amount of information about your database objects, provided you have access to them (talk to your DBA).
I suggest you do the following:
Figure out what specific information you actually need.
Figure out which DB catalogue views you need to look at in order to find this information.
Write the SQL to fetch that information from the relevant DB catalogue views.
Test your SQL on the database using your SQL interpreter (e.g. SQL*Plus or SQL Developer) with the appropriate user.
Then decide how you want to be able to access this data in future, and write a program to run the SQL as necessary.
If you try these things out but still have difficulties, come back and ask for help with a specific problem.
chris webster wrote:... provided you have access to them (talk to your DBA).
I always had the impression that ALL_* views are always available - they describe objects the user has been granted access to. Isn't it the case?
Sorry - you're right of course. I was thinking about all the other DBA-views that may not necessarily be visible to the user. I think I've been permanently scarred by my last project working on a site where the DB was so totally locked down that the Oracle developers were lucky if they could query DUAL!
subject: Fetch all constraints, schema name through java code from oracle database