RDBPROD: How to page through data using row number ( line number )
(Doc ID 1386160.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Rdb Server on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
Is it possible to page through generated output from an SQL query?
For example, to process 10 rows at a time in each execution of the same query:
select * from table .... return next 10 rows;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document