怎么建立insert update delete 触发器

如何建立insert update delete 触发器如何建立insertupdatedelete触发器[解决办法]Create Or Replace Trig

如何建立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;