local@ >select rownum,ename from emp;

    ROWNUM ENAME
---------- ----------
         1 SMITH
         2 ALLEN
         3 WARD
         4 JONES
         5 MARTIN
         6 BLAKE
         7 CLARK
         8 SCOTT
         9 KING
        10 TURNER
        11 ADAMS
        12 JAMES
        13 FORD
        14 MILLER

14 rows selected.

/* to get the 10 row */
local@ >SELECT ename FROM emp WHERE rownum=1 AND rowid NOT IN
  2     (SELECT rowid FROM emp WHERE rownum < 10);

ENAME
----------
TURNER

/*to get the 11th row*/
local@ >SELECT ename FROM emp WHERE rownum=1 AND rowid NOT IN
  2  (SELECT rowid FROM emp WHERE rownum < 11);

ENAME
----------
ADAMS