3 Replies Latest reply: Jul 19, 2013 5:36 AM by kiran_oracle RSS

    how can i get  the column name   for assigned constraint name  from  the  user_constraints   table?????

    kiran_oracle

      Hi  ,

      I  have a table  so  many constraints   on so  many  columns. I  need to  know  which column has which  constraint plsql dev?? like below...

       

      table_name -------- col_name ------ constraint_name_of_that_col

       

          xxxxxx              xxxxxxx              xxxxxxxxxxxxxxxx

       

       

      or else please let me know  how can i  get the  corresponding col_name for a particular  constraint name???