CREATE OR REPLACE TRIGGER trg_shippingorder_getbill_his
AFTER UPDATE
ON F_SHIPPINGORDER_GETBILL
FOR EACH ROW
BEGIN
if updating(‘LQUSER’) then
INSERT INTO F_SHIPPINGORDER_GETBILL_HIS VALUES (:OLD.SHIPPINGORDERKEY, :NEW.LQUSER, sysdate); --:old代表旧值
end if;
END;