<span style="font-family: Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255);">新增生效时间字段,对于新单此字段有值,对于历史数据此字段无值,查询不到相关历史数据问题</span>
CREATE OR REPLACE PROCEDURE pr_update_FIRSTLOCALE_EFFECTTM
declare
cursor cur_emp is select REACH_TM,FL_ID from T_AB_FIRSTLOCALE where REACH_TM is not null;
begin
--更新游标1
vcount:=0;
open cur_emp;
for return_cur in cur_emp
loop
update T_AB_FIRSTLOCALE
set EFFECT_TM = cur_emp.REACH_TM
where FL_ID=cur_emp.FL_ID;
if mod(vcount,500)=0 then
commit;
end if;
vcount:=vcount+1;
end if;
end loop;
close cur_emp;
Exception
When others then
Rollback;
end;