How to Interchange the Position of Columns in Reports at Runtime, Based on User Input (Doc ID 302398.1)

Last updated on OCTOBER 26, 2023

Applies to:

Goal

Suppose that it is required to display EMPNO and ENAME of the EMP table in the report output, and that the positions of these columns need to be interchanged at runtime, depending on a user parameter.

NOTE: In the example above and below, user details / company name / address / email /

telephone number represent a fictitious sample (based upon made up data

used in the Oracle Demo tables). Any similarity to actual persons, living or dead,

is purely coincidental and not intended in any manner.

Solution

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