plsql query return result into single row as concat

Question

select col1 from tablename returns 2 rows, i want to concat thse two rows data into single column as comma separated.

Answer 1

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

Answer 2

Here are some examples of same kind of situation: http://www.dba-oracle.com/t_converting_rows_columns.htm