Thanks. What about if SQL is written like this:
1. INSERT INTO schema.tab1 SELECT * FROM schema.tab2
or like this:
2. UPDATE schema.tab1 WHERE value = value (I would like to involke trigger on whole table)
My question: how many times is trigger fired out if ROW or STATEMENT is used in trigger for query 1 and query 2.
There is no hard and fast rule ... it depends on the business requirement rather than technical ...
For eg, consider and UPDATE trigger ... If the business requirement is to log before image of each row along with the update timestamp, then you will have to use ROW .. But, if the requirement is to just log the time when a table is updated, then use the STATEMENT
Visit the new-look IDUG Website , register to gain access to the excellent content.