Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Transpose rows into columns

shrnxtJun 25 2016 — edited Jun 27 2016

I have a table like:

Client     Process       Date                   Status

A              B                 21-june             Y

C             D                 22-june             N

A             B                 22-june             N

C            D                 21-june              Y

..

..

n rows

I want to display a report in the following format:

Client     Process        21-June         22-june        .. .... n colums

A               B                 Y                     N

C              D                    Y                     N

Please help...
This post has been answered by Barbara Boehmer on Jun 26 2016
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2016
Added on Jun 25 2016
#pivot
20 comments
4,450 views