触发器分为行级触发和语句触发。行级触发每影响一行执行一行。语句触发执行玩语句后触发一次,不管这条语句会影响多少行,都只触发一次。默认是语句触发。其语法规则为:
create [or replace] trigger <tri_name>
after|before|instand of
[insert or update [of column_name] or delete]
on <table_name>
[referrncing OLD as old / New as new]
[for each