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