how do i check the rules assign on check constraint on oracle sql?

[ravikumark]

Hi currently im getting unique constraint error. when i check the table there are check constraint assigned to few columns but i dont know what are the rules assigned to those check constraint. is there anyway i can check what rules has been assigned to those check constraint?

Thank you

[mollyren35]

As i know generally, you can retrieve the details of the check constraints and their associated rules from the system catalog or metadata views/tables in your DBMS.