SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get row number in the fetch row itself in Sql Query ?

bootstrapMay 20 2011 — edited May 20 2011

Hi,
i am fetching some rows from a sql query . Is there any way to get row number as well in each row while all rows are fetched ?

like this :

RowNum data1 data2
1 abc ere
2 bnh ioi

This post has been answered by 6363 on May 20 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 17 2011

Added on May 20 2011

4 comments

179 views