The Oracle of the limit returns a result set the size of the, similar to the MySQL limit (Translation)

MySQL | Oracle does not support is similar to the MySQL in the limit. but you can still rownum to limit the result set returned the number of rows.

If you wish to return in the top 10. record, you can write something like this:

SELECT * FROM table where rownum <10;

But the following statement is wrong:

SELECT * FROM table where rownum> 90 and rownum <100;

This is because the Oracle believes that this condition is not set up, so did not return.
You should write this:

SELECT * FROM table where rownum <101;
Minus
SELECT * FROM table where rownum <91;