I have Oracle 9i as the backend. My front screen has paging mechanism similar to Google.
The total number of records will be displayed say 1000
No of records per page will be 50
so now there will 20 pages that User can movew through using "Prev First Last Next" buttons.
How do i handle this from Oracle side?