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;