12c – SQL Query Row Limits and Offsets

Table created. 

insert into tabela_teste values (1,'Alex');
insert into tabela_teste values (2,'Joao');
insert into tabela_teste values (3,'Maria');
insert into tabela_teste values (4,'Pedro');
insert into tabela_teste values (5,'Paulo');
insert into tabela_teste values (6,'Fernando');
insert into tabela_teste values (7,'Rafael');
insert into tabela_teste values (8,'Samuel');
insert into tabela_teste values (9,'Daniel');
insert into tabela_teste values (10,'Luciano');
commit;

Commit complete.

SQL> select * from tabela_teste order by codigo desc fetch first 5 rows only;

   CODIGO NOME
---------- --------------------
    10 Luciano
     9 Daniel
     8 Samuel
     7 Rafael
     6 Fernando

SQL> select * from tabela_teste order by codigo desc offset 4 rows fetch next 4 rows only;

   CODIGO NOME
---------- --------------------
     6 Fernando
     5 Paulo
     4 Pedro
     3 Maria

SQL> select * from tabela_teste order by codigo desc fetch first 20 percent rows only;

   CODIGO NOME
---------- --------------------
    10 Luciano
     9 Daniel

Referências

http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_10002.htm#SQLRF55636

Abraço