CREATE OR REPLACE TRIGGER test
before UPDATE OR INSERT OF BODYPART ON T_PROCEDURE_test
FOR EACH ROW
declare
a varchar2(256);
BEGIN
select min(MODALITYS) into a from t_order_test where orderidentity=:new.ORDERIDENTITY;
if a='ZKDR' then
:new.bodypart:=replace(rtrim(:new.bodypart,';'),';','+')
;
end if;
exception when others then
null;
END;
/
触发器对本表操作
最新推荐文章于 2021-01-18 22:12:56 发布