What is a BEFORE 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 a BEFORE trigger?
Rating:
A BEFORE trigger executes the trigger action before the triggering statement is executed. It is generally used when the trigger action determines whether the triggering statement should be allowed to complete. By using a BEFORE trigger for this purpose, the unnecessary processing of the triggering statement and its eventual rollback (in case an exception is raised in the trigger action) can be eliminated.
BEFORE triggers are also used to derive specific column values before completing a triggering INSERT or UPDATE statement, initialize global variables or flags, and validate complex business rules.
Rating:
Was this information helpful?
Other articles
- What is dependency failure?
- What is overloading?
- What are OLD and NEW qualifiers?
- When is the recompilation of a dependent procedure or function unsuccessful?
- Things to practice for Oracle test 1Z0-147.