En 12c tu as le OFFSET : https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1

Exemple pour avoir la 10ème ligne

WITH t AS (SELECT LEVEL num FROM dual connect BY...