Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Merge Multiple Rows Into Single Result
nick_wakefield_at_hotmail.com (Niko) wrote:
>A cursor and a loop would be ideal, however I need to do it in a query
>not pl/sql. The sybase ASA List function would be cool but I don't
>know the oracle equivalent, never needed to know until now.
>
>
>Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3DD3D77C.FD124E08_at_exesolutions.com>...
>> Niko wrote:
>>
>> > Hi,
>> >
>> > Does anyone know a way to do the following, given a table like
>> >
>> > Field_A, Field_B
>> > a first word
>> > a second word
>> > a third word
>> >
>> > then runa group by query on it to merge the contents of field_b
>> > seperating with commas.
>> >
>> > select field_a, merge(field_b,',')
>> > from table
>> > group by a
>> >
>> > resulting in
>> > Field_A New_String
>> > a first word, second word, thrid word
>>
>> Given that you are the second person in as many days asking the same
>> question I can only presume that this is a class assignment ... so you
>> will need to figure it out yourself.
>>
>> Hint: It requires a cursor and a loop.
>>
>> Daniel Morgan
Received on Tue Nov 19 2002 - 08:34:15 CST
![]() |
![]() |