Dear Friends,
I have a query which returns 1 million record, Instead of returning 1 million rec I want to fetch in subset (1000 record per set ).
I did some research on the net and found I can use ROWNUM to retrieve the data in subset.
But the problem is, my table is updated with new rows every second.
First time the query might return 1 million, but second time the same query might return 1.5 million records.
My understanding is, the ROWNUM can be used for pagination if the query returns same number of records always.
How ROWNUM behaves in this situation, will it return duplicates? Will it ignore any records?
Please advice.
Thanks in advance,
I have a query which returns 1 million record, Instead of returning 1 million rec I want to fetch in subset (1000 record per set ).
I did some research on the net and found I can use ROWNUM to retrieve the data in subset.
But the problem is, my table is updated with new rows every second.
First time the query might return 1 million, but second time the same query might return 1.5 million records.
My understanding is, the ROWNUM can be used for pagination if the query returns same number of records always.
How ROWNUM behaves in this situation, will it return duplicates? Will it ignore any records?
Please advice.
Thanks in advance,
Comment