CREATE OR REPLACE TRIGGER test before UPDATE OR INSERT OF BODYPART ON T_PROCEDURE_test FOR EACH ROW declare PRAGMA AUTONOMOUS_TRANSACTION; 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; /
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; /
before UPDATE OR INSERT OF BODYPART ON T_PROCEDURE_test
FOR EACH ROW
declare
PRAGMA AUTONOMOUS_TRANSACTION;
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;
/
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;
/