Triggers, Rules and Events in Relational Databases


A trigger is the Oracle database equivalent of a rule. A rule is effectively something which is triggered as a result of a specified database event, such as inserting into one table triggers a rule which will insert another record into another table. Triggers, rules and events are generally used to enforce referential integrity and business rules.