Hi
My question is "how to concatenate all rows as a single row in a column in oracle?".For example consider a table "test" which having 1 column "col1".if the values of the column col is let it be a,b,c,d,e.

select * from test;
a
b
c
d
e

I need the output in the folowing format.
abcde.
Please help me.Thanks in Advance.

Thanks & Regards
RajendranR