Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need example for complex business rule where constraints cannot handle, but triggers does ....

User_3YG1KApr 7 2022

Hi,
Can anybody give me some example where complex business rule cannot be implemented by constraints, but triggers can do it.
"Enforce complex business or referential integrity rules that you cannot define with constraints "
the above line mentions the property of triggers . So, I need such an example for the above statement.
Link : https://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS723
Can any one plz....

Comments
Post Details
Added on Apr 7 2022
15 comments
1,014 views