I have a sql query which returns approx 500k records. I need to implement pagination so that I can get the records in steps of 1000.
I am trying to implement solution given in the post Paging with Oracle.
I have a question, is using rownum safe option as its temporary(A ROWNUM value is not assigned permanently to a row)?
Assume I run sql query with pageNo = 10 and pagesize = 1000. If i run this query 10 times, I am not getting same set of records.
Is there a better way to achieve this? I wanted to get same set of records every time i run query for particular pageno and pagesize.