Re: Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit

Dnia Wed, 25 Jun 2008 16:34:39 +0200, Norbert Winkler napisa³(a):

> The LIST Function
> Oleg Loa
> Dmitry Yemanov
> (v.2.1) This function returns a string result with the concatenated
> non-NULL values from a group. It returns
> NULL if there are no non-NULL values.
>
> Is there any equivalent in ORACLE 9?
>
> It seems that there is a COLLECT function in Oracle 10i
> (http://www.adp-gmbh.ch/blog/2005/march/28.html)
> But not so easy to use like LIST in FireBird.

You can check stragg function (it is user defined aggregate function).

-- 
Krzysztof Jamróz