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!

Transpose rows values to column dynamically in query

Azadare MJul 6 2015 — edited Jul 7 2015

Hi All,

I have table temp which having 3 columns Id, date_ and actual_values.

I need to transpose date_ column's values in columns and the actual_values column's values should be associate to date_ column and ID coulmn shoul be same..

But I need to pass two paraters to the query as date. min and max date and need to show only those records which comes under the date.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2015

Added on Jul 6 2015

21 comments

8,290 views