MERGE as a Triggering Action
If subquery returns no rows, then no triggers are fired.
Triggers invoke the following behavior when fired as the result of a MERGE request:
IF a trigger is defined on this type of action … |
THEN it is fired when this clause is specified … |
AND match_condition is … |
UPDATE |
WHEN MATCHED THEN |
met. |
DELETE |
WHEN MATCHED THEN |
met. |
INSERT |
WHEN NOT MATCHED THEN |
not met. |