If I have a catalog table with 100,000 rows, and I am displaying 500 rows per page using the pagination query.
If I need to display a dropdown list for all pages with data (word column) describing the data like this, so when user selects that page it displays the other rows
Page 1 (Row1 aaa - Row 499 bbb)
Page 2 (Row 500 ccc - Row 999 fff)
Page 3 (Row 1000 word - Row 1500 word)
How do you implement this (sql or plsql or dedicated table refreshed nightly)?
I dont think something like this would be efficient.
select word from (SUBQUERY for RESULTSET) where rownum in (1,499,500,999,....)
I know you dont like this but it is a must requirement for one application.