5436 reputação
--ORACLE PAGINATION
SELECT *
  FROM (SELECT A.*, ROWNUM RNUM
          FROM (SELECT * from USER_TABLES /*REPLACE WITH YOUR TABLE*/ C) A
         WHERE ROWNUM <= 3 --FIRST + ROWS
        )
 WHERE RNUM > 0 --FIRST