Re: Group functions

From: Mike Heisz <mheisz_at_rim.net>
Date: Thu, 22 Jul 1999 07:48:02 -0400
Message-ID: <newscache$ess9ff$wme$1@njord.rim.net>

I should clarify what I meant:
I want to write my own group function in pl/sql. Specifcally I wan to write a group concatenation function that will take the values in a query and concatenate them. The SQL would be something like:

select column1,CONCAT_GROUP(column2)
from ......
group by column1;

PL/SQL:
function CONCAT_GROUP IS
BEGIN

• how do I do this part? END;

Mike
Breno de Avellar Gomes <brenogomes_at_ieee.org> wrote in message news:37966D70.DE8C7D7A_at_ieee.org...
> Try this:
>
> SELECT AVG(cost), MAX(price) FROM products;
>
> Feel free to leave a note for more details.
>
> Regards
>
> Breno
>
>
> Mike Heisz wrote:
>
> > Does anyone know how to write (if posssible?) a function to be used in a
> > group function in SQL (i.e. something similar to avg)? I found mention
of
> > this possibility in the Oracle docs but there are no examples of how to
do
> > it.
> >
> > Mike
>
Received on Thu Jul 22 1999 - 06:48:02 CDT