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

From: Rad Thibodayox <cdt1968RemoveThis_at_hotmail.com>
Date: Fri, 05 Dec 2003 08:38:53 -0500
Message-ID: <3fd08a6c$1_2@news.unc.edu>

Daniel Morgan wrote:
> Rad Thibodayox wrote:
>

>> 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

>
>
> This is school work and as you can probably surmise we don't do other
> people's homework and exams.
>
> But you are entitled to a hint ... and the hint is that this requires a
> stored procedure. Think cursor. Think loop.
>

Hey Jackass,

You surmised wrong. I'm a SAS programer new to Oracle. This kind of thing can be done in a frigging data step in SAS. I just figured Oracle could handle it as easily.

Thanks for Nothing Jerk Received on Fri Dec 05 2003 - 07:38:53 CST