17,086
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
charli2000 2004-06-08
- 打赏
- 举报
多谢各位,结贴
wxyq 2004-06-08
- 打赏
- 举报
select count(*) into ii from table
for ...(i..ii/100 ?)
execute immediate "select a ,f1,f2 from select rownum a,f1,f2 from table
where a>="|| i|| "*100 and a<("|| i|| "+1)*100
next for
for ...(i..ii/100 ?)
execute immediate "select a ,f1,f2 from select rownum a,f1,f2 from table
where a>="|| i|| "*100 and a<("|| i|| "+1)*100
next for
dinya2003 2004-06-08
- 打赏
- 举报
建个函数或过程来执行.
beckhambobo 2004-06-07
- 打赏
- 举报
create function get_count(p_table in varchar2)
return number
as
num number;
begin
execute immediate 'select count(1) from '||p_table into num;
return trunc(num);
end;
/
select * from table_name where mod(rownum,get_count(table_name)/100)=0
return number
as
num number;
begin
execute immediate 'select count(1) from '||p_table into num;
return trunc(num);
end;
/
select * from table_name where mod(rownum,get_count(table_name)/100)=0
charli2000 2004-06-07
- 打赏
- 举报
呃...特例化了
如果是200条,就取出
第1,3,5,7条...
总之到最后查出小于等于100条记录..
如果是200条,就取出
第1,3,5,7条...
总之到最后查出小于等于100条记录..
jiezhi 2004-06-07
- 打赏
- 举报
select * from
(select rownum rn,a.* from a)
where mod(rn,100)=0
(select rownum rn,a.* from a)
where mod(rn,100)=0
charli2000 2004-06-07
- 打赏
- 举报
均匀取出是指如果有10000条，就是取出第1，100，200。。。。条记录。
