My Oracle Support Banner

How to Show Row Number in a Filtered Interactive Report? (Doc ID 2457719.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Application Express (APEX) - Version 4.0.0 to 5.1.4.00.08 [Release 4 to 5]
Information in this document applies to any platform.

Goal

How to have a row number in a column in an Interactive Report?

So that the row starts with the row number from 1 to n sequentially, always in a complete sequence regardless of the filtered results, an example:

1 Tom
2 Donald
3 Harry
4 Fred
...

NOTE: The example(s) provided are for demonstration purposes only and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.