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!

How to maintain Row num sequential order when report is sorted by another column.

User_4J5XKNov 2 2020

I have a report with a rownum column that when sorted the numbers gets mixed. Is there a way to keep the new sort order but have the rownum col in seq order?
Can a column exist external to the report that will not be affected then the report is sorted?
Sorted by Row
image.pngSorted by col B, row gets messed up.
image.png

This post has been answered by jariola on Nov 2 2020
Jump to Answer
Comments
Post Details
Added on Nov 2 2020
2 comments
351 views