1.存储过程批量更新
declare
v_int number;
v_loanid varchar(100);
v_tmName varchar(100);
v_tmMobile varchar(100);
v_tmPid varchar(100);
cursor yb is
select loanid,tmName,tmMobile,tmPid from bhzx_c1_tm;
begin
open yb; --打开游标
loop --开始标记
fetch yb into v_loanid,v_tmName,v_tmMobile,v_tmPid;--游标赋值 当然这边可以赋值多个值
update BHZX_D3_TM b1 set
b1.tmname = v_tmName,
b1.tmpid = v_tmPid,
b1.tmmobile = v_tmMobile
where b1.loanid = v_loanid;
v_int := v_int+1;
dbms_output.put_line('***');
dbms_output.put_line(v_int);
if(v_int >=5000) then
commit; --5000条提交一次 分单系统压力,提高上传的效率
v_int :=0;
end if;
exit when yb%notfound;--游标一条一条地遍历记录,当找不到记录时退出
end loop; --结束标记
commit;