I'am writing a web site using PL/SQL.The result from a select statement return
1000 records, I want cut them into 20 records per page (just like altavista
search engine), I am know using a counter to count until it reach 20 inside
the fetch statement. Is there a better way to fetch certain range of records
(for example 20th - 40th) from the return of a select statement.
Can I save the first search result to a temp table, so when user click "next
20" I don't have to issue the select statement again which will save a lot
time. But when I will drop the temp table?