Re: Concatenate Column Values from Multiple Rows into a Single Column

Hello,

Please see
http://asktom.oracle.com/pls/ask/f?p=4950:8:1664966181575824601::NO::F4950_P 8_DISPLAYID,F4950_P8_CRITERIA:2196162600402, Rgds.

"Rad Thibodayox" <cdt1968RemoveThis_at_hotmail.com> wrote in message news:3fcfe6cf$1_3_at_news.unc.edu...
> I would like to combine a field's values from multiple records in a
> single field. For example:
>
> Last First Code
> ------- --------- ----
> Lesand Danny 1
> Lesand Danny 2
> Lesand Danny 3
> Benedi Eric 7
> Benedi Eric 14
>
> Result should look like:
>
> Last First Codes
> ------- --------- -----
> Lesand Danny 1,2,3
> Benedi Eric 7,14
>
>
> Any help would be appreciated,
>
> Dwayne
>
Received on Fri Dec 05 2003 - 09:30:58 CST