Concatenating multiple rows?

From: D. Alvarado <laredotornado_at_zipmail.com>
Date: 24 Jun 2003 13:20:08 -0700
Message-ID: <9fe1f2ad.0306241220.530cadf7@posting.google.com>

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 Received on Tue Jun 24 2003 - 15:20:08 CDT