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

From: Krzysztof Jamrůz <SpAMkrzyh000JeST_at_ZLYo2.pl>
Date: Wed, 25 Jun 2008 20:24:19 +0200
Message-ID: <1rpzg31b7fwvp$.1hr195qwd3piy$.dlg@40tude.net>


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
Received on Wed Jun 25 2008 - 13:24:19 CDT

Original text of this message