another way may be using rownum..

select * from emp where rownum = 1


put it in procedure use cursor etc.,

row_num := 1

row_num := row_num + 2



select * from emp where rownum = :row_num;


This may help