Аналог MySQL limit n,m в Oracle

Question:

Is it possible to somehow organize the possibility of displaying the part of the query from n to m positions as it is implemented in MySQL by adding limit n,m to the query?

There is a solution to wrap in several queries, but not suitable due to the load on the database with such queries for "medium-large" tables:

select * from (select rownum as rn,* from ... where ...) d where d.rn between n and m

And the scan shows that the entire subquery is stored in memory.

Is it possible somehow to substitute n and m in the first query (nested)?

Answer:

Hi guys from 2011, I'm in 2015 now and we do this:

SELECT * FROM my_table
OFFSET 10 ROWS FETCH NEXT 5 ROWS ONLY;
Scroll to Top