What is a row 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 row trigger?
Rating:
A row trigger defined for a table is fired for each row of the table, which is affected by the triggering statement. For example, if an UPDATE statement updates multiple rows of a table, a row trigger is fired once for each row affected by the UPDATE statement. If the triggering statement does not affect any row, the row trigger is not fired.
A row trigger is created by using the FOR EACH ROW option with the CREATE TRIGGER statement. Row triggers are useful if the code in the trigger action depends on the data provided by the triggering statement or affected rows.
Rating:
Was this information helpful?
Other articles
- What is a procedure?
- What are OLD and NEW qualifiers?
- What is the EXECUTE IMMEDIATE statement?
- What is a function?
- When is the recompilation of a dependent procedure or function unsuccessful?
