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

"Norbert Winkler" <norbert.winkler1_at_gmx.de> wrote in message news:1v8hjno5av84.8ejksko31ji4$.dlg_at_40tude.net...
> Hello,
>
> The Firebird-Database 2.1 contains a LIST function
>
> http://www.firebirdsql.org/rlsnotes/Firebird-2.1-ReleaseNotes.pdf
> ____________________________
> 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.
> FormatData Manipulation Language (DML)
> 44
> <list function> ::=
> LIST '(' [ {ALL | DISTINCT} ] <value expression> [',' <delimiter value>
> ] ')'
> <delimiter value> ::=
> { <string literal> | <parameter> | <variable> }
> ____________________________
>
> 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.
>
>
> --
> Norbert

Other databases like SQLAnywhere have a list() function, but Oracle doesn't. Do a google search on 'oracle list function' and you can find examples of user defined functions.

-- 
Terry Dykstra