[sandhyab]

Below query returns row with coma separated column values. I would need some help if it is on primary column and not on ROW_NUMBER() OVER().

http://www.thescripts.com/forum/thread432951.html

WITH source(rn,name) AS (SELECT ROW_NUMBER() OVER() AS rc,
name
from table ),
rec(n,name) AS (SELECT 2,CAST(name AS VARCHAR(2000))
FROM source WHERE rn = 1
UNION ALL
SELECT n+1, rtrim(rec.name) || ',' || rtrim(source.name)
FROM source, rec WHERE n = rn)
SELECT name FROM rec ORDER BY n DESC FETCH FIRST ROW ONLY;

Thanks