1 min readJul 19, 2020
Also, since Oracle Database 12.1 you can use ANSI standard SQL 'paging' syntax like
SELECT employee_id, last_name
FROM employees
ORDER BY employee_id
OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;
Also, since Oracle Database 12.1 you can use ANSI standard SQL 'paging' syntax like
SELECT employee_id, last_name
FROM employees
ORDER BY employee_id
OFFSET 0 ROWS FETCH NEXT 5 ROWS ONLY;
Oracle Database Product Manager for language drivers including Python python-oracledb, Node.js node-oracledb, PHP OCI8 and more! On Mastodon: @cjbj@phpc.social