Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: User defined aggregate function
"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 CadotReceived on Tue Nov 23 2004 - 13:35:00 CST