In pagination, ordering is another important aspect that can not be missed. If you have hundreds of rows to display then it's best to use external pagination by asking the database to do pagination. In the case of internal paging, all data is loaded into memory in one shot and the display tag handles pagination based upon page size but it is only suitable for small data where you can afford those many objects in memory. Many Java programmer also uses display tag for paging in JSP which supports both internal and external paging.
In this article, we will see how to query Oracle 10g database for pagination or how to retrieve data using paging from Oracle. In fact, Database pagination is a common requirement of Java web developers, especially dealing with the largest data sets.
30 or 40 records at a time, which can be specified as the page size.
Many times we need an SQL query that returns data page by page i.e.