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!

Transpose columns of an ID into a row

MirithuNov 15 2021

Hi,
I am using PL/SQL and have a table that looks like below:
image.png
I would like to transpose the ContactDetail and ContactInfo for each customer ID into one row such that the final result looks like this:

image.pngHow do I accomplish this?

This post has been answered by Frank Kulash on Nov 15 2021
Jump to Answer
Comments
Post Details
Added on Nov 15 2021
4 comments
627 views