Using Triggers and Compound Triggers in Oracle 11g By Contributing Author on June 16, 2011 in Database Development , Oracle Database In database terminology, triggers are the objects which demonstrate the logic of schedule and automation. Triggers are automatically invoked at a defined event and timing without any explicit calls. The logic embedded within the trigger and invocation must be well directed and synchronized to maintain database purity. Oracle 11g made remarkable enhancements in Database Triggers. These enhancements and additions have transformed triggers into a logical, stable, and comprehensive database platform. In the past versions, developers used to face issues under certain conditions as listed below. Multiple triggers for single timing Mutating table confrontation Control the trigger execution by enabling and disabling it Introduction of compound triggers which triggers different logic at different timings, guaranteed execution sequence of t...