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 to rows

srikanth bMar 8 2021

C1 C2 C3
1 4 7
2 5 8
3 6 9
Expected result:
NEW_COL VALUE
C1 1
C2 4
C3 7
C1 2
C2 5
C3 8
C1 3
C2 6
C3 9
I Tried like below
SELECT 'C1' AS NEW_COL,C1 AS VALUE FROM TEST
UNION ALL
SELECT 'C2' AS NEW_COL,C2 AS VALUE FROM TEST
UNION ALL
SELECT 'C3' AS NEW_COL,C3 AS VALUE FROM TEST

NEW_COL VALUE
C1 1
C1 2
C1 3
C2 4
C2 5
C2 6
C3 7
C3 8
C3 9

This post has been answered by mathguy on Mar 8 2021
Jump to Answer
Comments
Post Details
Added on Mar 8 2021
3 comments
6,452 views