Fetchig first 11 to 20 records from 100 records in a select
843859Jan 9 2007 — edited Jan 10 2007i need to fetch 11 to 20 records from total 100 records on click of a button.
Initially i will be displaying 1 to 10 records and on click of a button i need to fetch from 11 to 20 . Any direction would be greatly helpful.
I can fetch all the 100 records and keep in session, but i want to avoid using much memory in session
TIA