In postgres to retrive first n rows we'll use the key word limit. In Oracle how this is possible.
For example in postgres,
select * from emp limit 10 /* retrives first 10 rows of emp */
In oracle this is possible by rownum
select * from emp where rownum <=10.
Is there any other way of doing it.