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?????


      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???