Blog Pages

Paging in Oracle

select * 
from (select rownum,fld1,fld2,fld3... from bigtable where <<CONDITION>> ) 
where rownum between 1 to 100 -- or between 101 to 200, and so on....

No comments:

Post a Comment