A: 数据插入之前更新
CREATE OR REPLACE TRIGGER TablesNameID before insert ON TablesName for each row begin --业务逻辑 end TablesNameID;
B：数据插入之后更新
CREATE OR REPLACE TRIGGER TablesNameID after insert ON TablesName for each row begin --业务逻辑 end TablesNameID;
C：数据更新之后更新
CREATE OR REPLACE TRIGGER TableNamesAfterUpdate after UPDATE ON TableNames FOR EACH ROW begin --业务逻辑 end;
D：数据更新之前更新
C：混合情况下的自动触发
CREATE OR REPLACE TRIGGER TabelNameTrigger before INSERT OR UPDATE ON TableName FOR EACH ROW DECLARE --参数 BEGIN --业务逻辑 if :new.texture = ‘铜丝‘ then :new.texture := ‘Cu‘; end if; if :new.texture = ‘金丝‘ then :new.texture := ‘Au‘; end if; END;
原文：https://www.cnblogs.com/jeremywucnblog/p/11399121.html
