top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How do I display row number with records in Oracle?

+1 vote
464 views
How do I display row number with records in Oracle?
posted Mar 11, 2015 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
 
Best answer

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

answer Mar 12, 2015 by Arun Gowda
...