Home » SQL & PL/SQL » SQL & PL/SQL » show in one line
icon6.gif  show in one line [message #299416] Mon, 11 February 2008 23:35 Go to next message
rajesh2003
Messages: 1
Registered: February 2008
Location: INDIA
Junior Member
hi

This is my table

CODE NAME
----- -----------
1 U.K
1 FRANCE
2 GERMANY

I need like this

CODE NAME
------- --------
1 U.K,FRANCE
2 GERMANY

REGARDS
Re: show in one line [message #299429 is a reply to message #299416] Tue, 12 February 2008 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As for all others that posted the same question yesterday: search for "pivot".

Regards
Michel
Re: show in one line [message #299467 is a reply to message #299429] Tue, 12 February 2008 02:44 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That's what I've told him yesterday (via Private messaging system), but - obviously - didn't help much. Perhaps you'll be more lucky Smile
Re: show in one line [message #299472 is a reply to message #299467] Tue, 12 February 2008 02:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hey! I also did this in PM yesterday.

Regards
Michel
Re: show in one line [message #299520 is a reply to message #299472] Tue, 12 February 2008 05:34 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Why all the PM-ing? This is a forum. Solutions belong in public replies..
Re: show in one line [message #299530 is a reply to message #299520] Tue, 12 February 2008 05:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It wasn't a "discussion" and I do not want to do that via PM's. However, as the solution was a single 5-letters word, I thought that I could share it. Waste of time.

My answer to his PM
I'm sorry, but I will not discuss your (or anyone else's) problems via private messages. Ask the question in the appropriate forum (Newbies in this case). A hint: search for "pivot".
Re: show in one line [message #299532 is a reply to message #299530] Tue, 12 February 2008 06:03 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
More or less same message from me.

Regards
Michel

[Updated on: Tue, 12 February 2008 06:03]

Report message to a moderator

Previous Topic: Generate the file having dynamic columns
Next Topic: execute query in sqlplus
Goto Forum:
  


Current Time: Sat Dec 10 11:10:08 CST 2016

Total time taken to generate the page: 0.07678 seconds