1.设置不同时间触发的效果
PS: 为达到 见名知意 的效果, 建议统一命名规则, 触发器以 TRG_ 开头, 函数以 F_ 开头
--创建触发器 CREATE OR REPLACE TRIGGER TRG_WLZSJ_CODE_DESCLONG0514 --设置触发器触发条件,after/insert after INSERT OR UPDATE ON MDM_WLZSJ_CODE FOR EACH ROW --定义变量 declare V_desclong VARCHAR2(2000); V_descshort VARCHAR2(2000); V_count VARCHAR2(2000); PRAGMA AUTONOMOUS_TRANSACTION; BEGIN --仅在更新时执行 if updating then --调用自定义函数处理数据 select F_DESCRIBE(desclong) into V_desclong from mdm_wlzsj_code where codeid = :new.codeid; select F_DESCRIBE(descshort) into V_descshort from mdm_wlzsj_code where codeid = :new.codeid; :new.desclong := F_DESCRIBE(:new.desclong); :new.descshort := F_DESCRIBE(:new.desclong); end if; --仅在插入时执行 if inserting then :new.desclong := F_DESCRIBE(:new.desclong); :new.descshort := F_DESCRIBE(:new.desclong); end if; END TRG_WLZSJ_CODE_DESCLONG0514;