Re: Concatenating multiple rows?

"D. Alvarado" wrote:

> Hi,
> Is it possible to concatenate multiple rows of data in a single
> select statement. For example, if my table was
>
> FIELD1
> ------
> aaa
> bbb
> ccc
>
> is there a way in Oracle to have a single select statement that could
> produce
>
> 'aaa,bbb,ccc'?
>
> Thanks - Dave

Unless you can yuse CONNECT BY you will need to use a PL/SQL loop.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)