Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit
From: Norbert Winkler <norbert.winkler1_at_gmx.de>
Date: Wed, 25 Jun 2008 16:34:39 +0200
Message-ID: <1v8hjno5av84.8ejksko31ji4$.dlg@40tude.net>
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> ::=
Date: Wed, 25 Jun 2008 16:34:39 +0200
Message-ID: <1v8hjno5av84.8ejksko31ji4$.dlg@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.
-- NorbertReceived on Wed Jun 25 2008 - 09:34:39 CDT