Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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)Received on Tue Jun 24 2003 - 15:23:35 CDT
![]() |
![]() |