Skip to Main Content

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!

Dynamic pivot query?

ab_romanApr 29 2019 — edited Apr 29 2019

Dear All,

I have a table data like below: table may have more record with different date.. if the table has more rows report colums need to increase to display the values.

param1 date1 value1 value2 value3

param2 date1 value1 value2 value3

param1 date2 value4 value5 value6

param2 date2 value4 value5 value6

...

I want to display like below in apex report:

Paramdate
date
date...
param1 value1 value2 value3value4value5value6
param2value1value2 value3value4value5value6

I can't find a way to do this, could you please help...

any help is highly appreciated.

kind regards,

roman

Comments

Post Details

Added on Apr 29 2019
3 comments
1,056 views