Home » SQL & PL/SQL » SQL & PL/SQL » Tranposed output
Tranposed output [message #392952] Thu, 19 March 2009 15:42 Go to next message
Messages: 29
Registered: November 2006
Junior Member

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?

Re: Tranposed output [message #392961 is a reply to message #392952] Thu, 19 March 2009 17:11 Go to previous messageGo to next message
Messages: 25352
Registered: January 2009
Location: SoCal
Senior Member
>Could any one of you suggest the idea?
You need to help us by following the Posting Guidelines as stated below.
Re: Tranposed output [message #393006 is a reply to message #392952] Fri, 20 March 2009 00:15 Go to previous message
Michel Cadot
Messages: 64728
Registered: March 2007
Location: Nanterre, France, http://...
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.

Could any one of you suggest the idea?

We have no idea of what should be the result, explain it with words.

Previous Topic: Storing table coumn name from source table into column value in target table
Next Topic: PL/SQL - Unix Modify Permission
Goto Forum:

Current Time: Thu Apr 27 08:17:19 CDT 2017

Total time taken to generate the page: 0.10686 seconds