Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_5

5. Pagination and Set Operators

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Working with large sets of data is quite common when an Oracle Database is involved. But not always should all the data be shown to the user of a database application. Often, only the first 50 records are enough for users to interact with. A typical top-N query is examined in this chapter, retrieving the first 50 records. Showing the following 50 records, or any offset is an example of a pagination-type query that ...