the following is what I cut down from the same forum long time ago, thanks to the contributor.

To have records from 10 to 20
do
select * from emp where rownum < 21
minus
select * from emp where rownum < 11;

Cheers.