What is a statement 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 statement trigger?
Rating:
A statement trigger defined for a table is fired once on behalf of the triggering statement, regardless of the number of affected rows. A statement trigger fires even if no rows of the table are affected at all. For example, if a DELETE statement deletes multiple rows from a table, the statement-level DELETE trigger defined on the table is fired only once.
Statement triggers are useful if the code in the trigger action does not depend on the data provided by the triggering statement or affected rows. A statement trigger is generally used to make a complex security check on the current time or user, generate a single audit record, etc.
Rating:
Was this information helpful?
Other articles
- What are the restrictions on a user-defined function that is called from a SQL expression?
- What are OLD and NEW qualifiers?
- What are the advantages of using user-defined functions in SQL expressions?
- How does Oracle server manage dependencies among objects?
- What are the different subprograms provided with the DBMS_JOB Oracle supplied package?