触发器,修改表里面的字段时将该字段另存到另一字段的触发器create or replace trigger tb_sm_user_update_
触发器,修改表里面的字段时将该字段另存到另一字段的触发器
create or replace trigger tb_sm_user_update_trigger before update of USER_ORGID on tb_sm_user for each rowdeclarebegin if :NEW.USER_ORGID!=:OLD.USER_ORGID then :NEW.original_orgid:=:OLD.USER_ORGID; end if;end;
