OracleÓÃÓαê·Ö½âºÅÂë´ÎÊý

drop table tb_wjf_xh_dg100_50_tmp4 purge; 
create table tb_wjf_xh_dg100_50_tmp4
 (
 servnumber varchar(11)
 )
;
  
declare
      vv_cusor_servnumber  varchar2(32);
      vv_cusor_lost_cnt    integer;
      vv_servnumber_tmp  varchar2(32);
      vv_lost_cnt_tmp    integer;
      cursor v_cursor is
      select servnumber,lost_cnt from tb_wjf_xh_dg100_50_tmp3;
begin
    open v_cursor;
    loop
        fetch v_cursor into vv_cusor_servnumber, vv_cusor_lost_cnt;
      exit when  v_cursor%notfound;
     
     vv_servnumber_tmp := vv_cusor_servnumber;
     vv_lost_cnt_tmp := vv_cusor_lost_cnt;
    
     while(vv_lost_cnt_tmp > 0) loop
    insert into tb_wjf_xh_dg100_50_tmp4 values(vv_servnumber_tmp);
      commit;
      vv_lost_cnt_tmp := vv_lost_cnt_tmp-1;
     end loop;
    
    end loop;
    close v_cursor;
end;
/