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!

SQL Query to transpose data

User_6BAVRFeb 12 2021

Hi Community!
First post here... ;)
I am having difficulties creating a SQL query for a Oracle 12 DB to return a table in a specific way.
I guess the picture below should help describe the structures.
image.pngI tried some pivot, but it seems it is used with count and I was not successful.
Some hints, please?
Really appreciate any help!
Thanks,
Juliano.

Comments
Post Details
Added on Feb 12 2021
3 comments
9,572 views