Home » SQL & PL/SQL » SQL & PL/SQL » concat (Oracle 9i)
concat [message #445910] Thu, 04 March 2010 12:12 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi Experts,

I have a table with 10,000 like this

SNO CODE
1 A
1 B
1 C
1 D
1 E
2 F
2 G
2 H
2 I
3 J
3 K
........
....
...
...
etc

I want to display the output like this

SNO CODE
1 A,B,C,D,E
2 F,G,H,I
3 J,K
......
.....
etc


Please help me.
Thanks in advance
Re: concat [message #445914 is a reply to message #445910] Thu, 04 March 2010 12:18 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

This is a FAQ & you'll find many similar posts here if you search for PIVOT or 'CONNECT BY'
Re: concat [message #445916 is a reply to message #445910] Thu, 04 March 2010 12:23 Go to previous messageGo to next message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Too late! this has already been asked this week, we allow only ONE such question per week.
Try to be the first one next week.

Regards
Michel
Re: concat [message #445958 is a reply to message #445910] Thu, 04 March 2010 21:59 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
./fa/2115/0/

regards,
Delna
Re: concat [message #446003 is a reply to message #445910] Fri, 05 March 2010 02:06 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Tom Kyte's STRAGG function also does this very well
Previous Topic: Newton-Raphson method with sql
Next Topic: Truncate and checkpoint
Goto Forum:
  


Current Time: Sat Oct 01 02:32:39 CDT 2016

Total time taken to generate the page: 0.12042 seconds