CREATE OR REPLACE TRIGGER up_conflag
before UPDATE OF excute_num ON sales_control_bill
FOR EACH ROW
BEGIN
if :new.excute_num >= :old.turn_num then
:new.excute_flag = 'C';
end if;
end;
before UPDATE OF excute_num ON sales_control_bill
FOR EACH ROW
BEGIN
if :new.excute_num >= :old.turn_num then
:new.excute_flag = 'C';
end if;
end;
before UPDATE OF excute_num ON sales_control_bill
FOR EACH ROW
BEGIN
if :new.excute_num >= :new.turn_num then --根据你的规则,似乎该这样
:new.excute_flag = 'C';
end if;
end;