Getting Constraints Information

[Morpheus1981]

Hi, I am using "user_constraint" in order to get Data Dictionary directly from the Database but I only can get delete_rule field, but I would like to know the Update_rule and Insert_Rule as well.

Does anyone now how I can get this information from ORACLE DataBase? (It can be any not only through user_constraint view).

Thank you.

 

[sem]

DELETE rule is the only rule maintained by Oracle automatically. If you need UPDATE rule, you should implement your own logic using triggers. As for INSERT rule, do you know any options for it? Regards, Dima