top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

How can I convert the columns into Rows in Oracle?

0 votes

I have a requirement to convert the columns of a table into Rows?


Table T1

C1     C2
X         Y
A         B

The output should be

X     A
Y     B

Help me to sort out this issue.

posted Aug 17, 2014 by Ela

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote

The function PIVOT transposes rows in columns and the function UNPIVOT transposes columns in rows. They have been added in 11g. You can try that.

answer Aug 17, 2014 by anonymous
0 votes
StudentID int ,
Marks1 float,
Marks2 float,
Marks3 float

INSERT INTO #Student VALUES (1, 5.6, 7.3, 4.2)
INSERT INTO #Student VALUES (2, 4.8, 7.9, 6.5)
INSERT INTO #Student VALUES (3, 6.8, 6.6, 8.9)
INSERT INTO #Student VALUES (4, 8.2, 9.3, 9.1)
INSERT INTO #Student VALUES (5, 6.2, 5.4, 4.4)

SELECT * FROM #Student

SELECT StudentID, MarksNo, MarksRecd
(SELECT StudentID,
Marks1, Marks2, Marks3
FROM #Student) stu
(MarksRecd FOR MarksNo IN (Marks1, Marks2, Marks3)
) AS mrks
answer Nov 17, 2014 by Manikandan J
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.