Concatanating results in one string

Hi,

I'm trying to do a query to return all the values in one column concatanated as if it was only one result:

Field

select ??? from table ==> "ABC"

Is this possible?
I've looked the SQL reference, but I can't find anything there (the concat function doesn't seem to allow this, does it?)

I'm using Oracle 8.1.7

Thanks in advance! Received on Wed Nov 13 2002 - 07:24:20 CST