Home » SQL & PL/SQL » SQL & PL/SQL » Need the query
Need the query [message #184638] Thu, 27 July 2006 04:59 Go to next message
gold_oracl
Messages: 129
Registered: July 2006
Location: Westborough, MA
Senior Member
hi all,
my table temp_table contain two columns they are id number, name varchar2(20)
the records are
ID NAME
10 AAA
10 BBB
10 CCC
20 CCC
30 DDD
20 BBB
50 DDD

i want the result set like given below(row to column conversion)
ID NAME
10 AAA,BBB,CCC
20 CCC,BBB
30 DDD
50 DDD

the number if rows will vary......
here i used to do PL/SQL. is there any direct way to accomplish this?

Thanks,
Thangam
Re: Need the query [message #184640 is a reply to message #184638] Thu, 27 July 2006 05:06 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please search before posting.
http://www.orafaq.com/forum/m/35139/0/
Previous Topic: ref cursor
Next Topic: Insert is too slow......
Goto Forum:
  


Current Time: Thu Dec 08 19:55:24 CST 2016

Total time taken to generate the page: 0.05642 seconds