Home » SQL & PL/SQL » SQL & PL/SQL » Concating column data as row
Concating column data as row [message #252208] Wed, 18 July 2007 02:43 Go to next message
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
Member

Table A
col1
------
100
101

Table B

col1 col2
------- ------
100 1
100 2
100 3
101 1
101 2





i would like to see output like


Output table

col1 col2
----- -----
100 1,2,3
101 1,2


can any one give idea to solve this
Re: Concating column data as row [message #252210 is a reply to message #252208] Wed, 18 July 2007 02:47 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the pivot of the day.
Search for "pivot".
Topic closed.
./fa/448/0/
Regards
Michel
Previous Topic: error ORA 27101
Next Topic: bulk collect updates using joins
Goto Forum:
  


Current Time: Sun Dec 11 08:02:50 CST 2016

Total time taken to generate the page: 0.09445 seconds