HOW TO DISPLAY SECOND OR THIRD ECT ROW INDIVIDUALLY

HI,

TO PRINT THE INDIVIDUAL ROWS 

select * from (select rownum rno,*.emp  from emp)

where rno=&rno;

EXPLANATION:

when user gives the user defined number for the 'rno',the system will first executes the sub query then passes the bind patameters corresponding rownum.