3,491
社区成员
发帖
与我相关
我的任务
分享
在程序端做处理就好了!
select count(1) into v_max_rownum from ct_intf_sf.bus26003_11090001a@ct_intf_online;
while v_cur_rownum < v_max_rownum loop
insert /*+append parallel(4)*/
into audi.total_bus26003_sf nologging
(twi_id,
tbw_id,
ck_state,
state,
file_row,
file_name,
field1,
field2,
field3,
field16)
select audi.seq_total_bus26003_sf.nextval,
'353',
'S',
'N',
null,
null,
nvl(cust_id,'null'),
nvl(cert_type,'null') ,
nvl(state ,'null'),
nvl(cert_number,'null')
from (select rownum num,a.* from ct_intf_sf.bus26003_11090001a@ct_intf_online a
where rownum <=v_cur_rownum+1000000) b where b.num>v_cur_rownum;
commit;
v_cur_rownum := v_cur_rownum + incr_num;
end loop;