Christopher Jones
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;

--

--

Christopher Jones
Christopher Jones

Written by Christopher Jones

Oracle Database Product Manager for language drivers including Python python-oracledb, Node.js node-oracledb, PHP OCI8 and more! On Mastodon: @cjbj@phpc.social

No responses yet