Are you looking some thing>>>>

SQL> select rownum, ename, sal from emp;

ROWNUM ENAME SAL
--------- ---------- ---------
1 SMITH 800
2 ALLEN 1600
3 WARD 1250
4 JONES 2975
5 MARTIN 1250
6 BLAKE 2850
7 CLARK 2450
8 SCOTT 3000
9 KING 5000
10 TURNER 1500
11 ADAMS 1100
12 JAMES 950
13 FORD 3000
14 MILLER 1300

14 rows selected.