Skip to Main Content

APEX

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!

Show the Rown Number in a Interactive Report

GR81Aug 30 2012 — edited Sep 11 2012
I would like to know how I can (dynamically) have a row number in a column in an Interactive Report? It is a computation, if so what should it look like?

It should be as such that the row starts with the row number from 1 to n sequentally, always in a complete sequence regardless of the filtered results, e.g.

1 Tom
2 Donald
3 Harry
4 Fred
...
n

(This should not be confused with ROWNUM or ROWID.)

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2012
Added on Aug 30 2012
15 comments
3,898 views