here i meant scroll is where condition..... for every scroll i will be giving 1000 records...

For the 1st time i will return 1000 records and next time 1001 to 2000 on 1 million rows which is sorted (order by )