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

On 25 jun, 16:34, Norbert Winkler <norbert.winkl..._at_gmx.de> wrote:
> 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

You may take a look here

http://carlosal.wordpress.com/2007/06/26/convertir-tablas-resultsets-a-cadenas/

It's only SQL, but I like it! ;)

HTH. Cheers.

Carlos. Received on Wed Jun 25 2008 - 13:06:48 CDT