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.