yes, it is.
konghou wrote:
> I don't think it's an assignment... I would like to know if it's
> possible to write a GENERIC user-defined AGGREGATE function in oracle.
>
> 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 Fri Nov 15 2002 - 02:55:11 CST