How do I flip a query result onto its side?

[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...

 

[r937]

do this with your front end scripting language, not with sql

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)