How do I display row number with records in Oracle?

Answer 1

To achive this use rownum pseudocolumn with query, like
SQL> SQL> select rownum, ename from emp;
Output:
1 Scott
2 Millor
3 Jiyo
4 Smith