Home » SQL & PL/SQL » SQL & PL/SQL » Tranposed output
Tranposed output [message #392952] Thu, 19 March 2009 15:42 Go to next message
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 #392961 is a reply to message #392952] Thu, 19 March 2009 17:11 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
http://www.orafaq.com/forum/t/88153/0/
Re: Tranposed output [message #393006 is a reply to message #392952] Fri, 20 March 2009 00:15 Go to previous message
Michel Cadot
Messages: 64152
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.

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
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: Sat Dec 10 14:43:46 CST 2016

Total time taken to generate the page: 0.08133 seconds