如何建立insert update delete 触发器
如何建立insert update delete 触发器
[解决办法]
Create Or Replace Trigger TRIGGER_NAME
After Insert Or Update Or Delete On TABLE_NAME
For Each Row
Begin
--当操作类型为增加时
IF INSERTING THEN
...;
--当操作类型为修改时
ELSIF UPDATING THEN
...;
ELSIF DELETING THEN
...;--只有old值
END IF;
END TRIGGER_NAME;
