Skip to Main Content

Developer Community

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!

Oracle pivot question

Vijaya DasariAug 30 2025

Hi Group,

I have data coming as below

LoanNumber

Attribute name

Attribute Value

layer

L1

Threshold

EWT

Source

L1

Threshold

LWT

Target

L1

Classfication

A

Source

L1

Classfication

A1

Target

Need to transform it to output as below, please help me how can I achieve this

LoanNumber

Attribute name

Source Attribute Value

Target Attribute Value

L1

Threshold

EWT

LWT

L1

Classfication

A

A1

This post has been answered by Solomon Yakobson on Aug 31 2025
Jump to Answer
Comments
Post Details
Added on Aug 30 2025
6 comments
37 views