Re: Merge Multiple Rows Into Single Result

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 - 09:06:02 CET