n=0;
select count(*) into :total from table;
do while ...
select * from table where rownum>5*n and rownum<=5*n+5 and rownum<=total;
n= n+1;
end ...
select count(*) into :total from table;
do while ...
select * from table where rownum>5*n and rownum<=5*n+5 and rownum<=total;
n= n+1;
end ...
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货