Not yet, I have simulated functions using pl/sql but they where not true aggregates.
brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0211150006.79ac6403_at_posting.google.com>...
> 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 Tue Nov 19 2002 - 01:02:33 CST
