Home » SQL & PL/SQL » SQL & PL/SQL » convert rows to column in SQL (12C)
convert rows to column in SQL [message #679442] Fri, 28 February 2020 23:43 Go to next message
Messages: 1
Registered: February 2020
Junior Member
Dear All,

I want to convert rows to column in SQL, but list aggregate is not helping me.
Any suggesstion are welcome.

Re: convert rows to column in SQL [message #679444 is a reply to message #679442] Sat, 29 February 2020 00:58 Go to previous message
Michel Cadot
Messages: 68055
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 100 characters when you format.
Indent the code, use code tags and align the columns in result.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

I want to convert rows to column in SQL

Have a look at PIVOT/UNPIVOT clause of SELECT.

[Updated on: Sat, 29 February 2020 00:59]

Report message to a moderator

Previous Topic: embedded implicit cursors in SQL
Next Topic: Select statement inside IF statement for comparing a given string with records in table
Goto Forum:

Current Time: Thu Dec 09 05:28:29 CST 2021