One page of query and the total it matches, with OFFSET … FETCH NEXT.
The query needs an orderBy (end it with a unique column): Oracle returns
rows in no set order without one, so pages would repeat or skip rows. Runs
the page and a count on db, which may be a transaction's.
One page of
queryand the total it matches, with OFFSET … FETCH NEXT. The query needs an orderBy (end it with a unique column): Oracle returns rows in no set order without one, so pages would repeat or skip rows. Runs the page and a count ondb, which may be a transaction's.