Tranposed output [message #392952] |
Thu, 19 March 2009 15:42  |
pradkuamr
Messages: 29 Registered: November 2006
|
Junior Member |
|
|
Hi
I am having an input data set as follows
C1 C2 C3
john 123 Europe
John 324 Asia
I am looking for a transposed output as follows With three columns
C1 C2 C3
John Europe (123) Asia (324)
Could any one of you suggest the idea?
Thanks
Pradkumar
|
|
|
|
Re: Tranposed output [message #393006 is a reply to message #392952] |
Fri, 20 March 2009 00:15  |
 |
Michel Cadot
Messages: 68733 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter), use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).
Post a Test case: create table and insert statements along with the result you want with these data.
Quote: | Could any one of you suggest the idea?
|
We have no idea of what should be the result, explain it with words.
Regards
Michel
|
|
|