how to write a query to select Nth row from a table in Oracle SQL?

Question

suppose if i give '12345'

output should be:

1
12
123
1234
12345
1234
123
12
1

Answer 1

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum< &Start);

Inout:
Enter value for upto: 10
Enter value for Start: 7

output:
ROWNUM EMPNO ENAME

---

1 7782 CLARK
2 7788 SCOTT
3 7839 KING
4 7844 TURNER

Answer 2

SELECT * FROM
(SELECT ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS SAL, * FROM TABLE2) sub
WHERE SAL = n

n-Give the nth row number or if you want which row then give it that row number