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
- Skills required for Oracle test 1Z0-147.
- Developing an Oracle Application.
- What is DBMS_JOB Oracle supplied package?
- What are the advantages of using packages?
- What is a bodiless package?