What is an AFTER trigger?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is an AFTER trigger?
Rating:
An AFTER trigger executes the trigger action after the triggering statement is executed. An AFTER trigger is generally used to perform different actions on the same triggering statement if a BEFORE trigger is already present.
When using triggers to provide sophisticated auditing, AFTER triggers are given priority. By using AFTER triggers, auditing information is recorded after the triggering statement is subjected to applicable integrity constraints, thereby preventing cases where the audit processing is carried out unnecessarily for statements that generate exceptions to integrity constraints.
Rating:
Was this information helpful?
Other articles
- What is trigger timing?
- What is the UTL_HTTP Oracle supplied package?
- When is the recompilation of a dependent procedure or function unsuccessful?
- How is a SQL statement executed?
- What are the components of a DML trigger?