Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: User defined aggregate function

Re: User defined aggregate function

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 23 Nov 2004 20:35:00 +0100
Message-ID: <41a38fe9$0$17715$636a15ce@news.free.fr>

"Patrick Mézard" <patrick.mezard_at_ifrance.com> a écrit dans le message de news:41a388f7$0$17378$8fcfb975_at_news.wanadoo.fr...

<snip>

> Is there any way to write something like:
> ---
> select stragg(values, ', ') from table;
> ---
>

 No, but you can do something like:

select stragg(stragg_type(values, ', ')) from table;

User defined aggregate function can have a parameter of composite type.

-- 
Regards
Michel Cadot
Received on Tue Nov 23 2004 - 13:35:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US