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 are the guidelines for designing triggers?
- What are the methods used to pass values to parameters in a procedure?
- What is the syntax for creating a function?
- What are the restrictions regarding the overloading of subprograms?
- What is dynamic SQL?