plsql query return result into single row as concat

Question

select col1 from tablename

returns 2 rows, I want to concat these two data rows into a single column separated by a comma.

possible duplicate of [How can I combine multiple rows into a comma-delimited list in Oracle?](http://stackoverflow.com/questions/468990/how-can-i-combine-multiple-rows-into-a-comma-delimited-list-in-oracle) — Ben, Nov 15 '12 at 20:58

score 0 · Accepted Answer · answered Oct 22 '10 at 08:32

0

You can write a cursor to loop through the returned rows one by one and concatenate as you like.

answered Oct 22 '10 at 08:32

Johnbabu Koppolu

NO i need to do it only using a query – d-man Oct 22 '10 at 09:09
@Faisal Khan - Daniel Emge's solution here should be helpful for you.http://stackoverflow.com/questions/468990/how-can-i-combine-multiple-rows-into-a-comma-delimited-list-in-oracle – Johnbabu Koppolu Oct 22 '10 at 09:15

score 0 · Answer 2 · answered Oct 22 '10 at 09:21

0

answered Oct 22 '10 at 09:21

Jokke Heikkilä

I checked that the first one is at least working with no problems. – Jokke Heikkilä Oct 22 '10 at 10:14

2 Answers2