SQL & PL/SQL

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!

Convert column values to header

RajanikantFeb 4 2026

Hi,

Below is my requirement, please note that final output which I am posting is getting derived using SQL and not stored in any table directly.

Basically after doing multiple calculations using SQL based on few tables below is my data (this data is still not yet stored anywhere as I need to do all these in one SQL report),

EE# ATTRIBUTE1 ATTRIBUTE1_VALUE

1 NI Number X

1 NI Issue Date to_date('01/01/2025')

2 NI Number Y

Please note that attribute1 (NI Number, NI Issue Date are dynamic and can have other values also). I would like to convert those values to column header dynamically.

Output should be

EE# NI Number NI Issue Date

1 X to_date('01/01/2025')

2 Y

I have checked few links where it says PIVOT supports static values, please note that in my environment dynamic SQL is not supported. any suggestions please.