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 ...
© 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_55. Pagination and Set Operators
(1)
Oosterhout, Noord-Brabant, The Netherlands
(2)
Almere, Flevoland, The Netherlands
Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
