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

mdtaylor

If you look at the Installation Guide that ships with 12.2.4 and 12.2.4.1 Demantra, you will see Windows 2012 is also supported.  You can just install the Administrative Tools on the new server.

I have seen clients upgrade Windows 2008 to Windows 2012, leaving the Demantra installations intact.  Most Windows Admins prefer to do a fresh installation though.

User_3LS60

Thank you for the reply. can you please provide steps for 12.2.4.1  Administrative Tools on the new server without changing anything on Solaris machines. iam new to Demantra. please help.

Prashant Umap

Hello,

You need to install demantra (Software only) only on new server. I will help you to setup.

Let me know if you need any other help.

Prashant

1 - 3

Post Details

Added on Apr 29 2019
3 comments
1,059 views