how do i flip query result? 1

[navrsalemile]

Hi,

I wonder if anybody can help me with this. I have a query which returns single column:

cntr
=====
55555
44444
...

The numbers can be different depending on the WHERE condition, but the number of rows can be limited to 10.

No I would like this result to be shown as:

cntrs
=================
55555, 44444, ...

i.e. as one row and values separated by commas.
I assume I cannot use DECODE since the values from the original query can be different i.e. not known in advance, but not sure...

 

[sem]

select max(decode(rownum,1,cntr))||','||
max(decode(rownum,2,cntr))||','||
....
max(decode(rownum,10,cntr))
from ...

Regards, Dima

http://seminihin.narod.ru