My Oracle Support Banner

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

Last updated on JANUARY 10, 2020

Applies to:

Oracle Reports Developer - Version and later
Information in this document applies to any platform.



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.



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

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