select provcode from table_a
open cur_mms_send;
loop
fetch cur_detail bulk collect into
l_ary_provcode_tmp1
limit 10000;
forall i in 1..l_ary_provcode_tmp1.count
insert
into sms_down
(
provcode
)
values
( l_ary_provcode_tmp1(i) ); commit;
exit
when cur_mms_send%notfound or cur_mms_send%notfound is
null;
end loop;
close cur_mms_send;
上面本来可以用一条语句实现
Insert into sms_down
select provcode from table_a ;
而且也没有发生PLSQL 和SQL的切换.
NAME VALUE
---------------------------------------------------------------- ----------
CPU used by this session 103
redo size 260168
undo change vector size 57544
insert /*+ append */ into maclean_forall2 select * from maclean_forall