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 Firebird-Database 2.1 contains a LIST function


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)
<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
But not so easy to use like LIST in FireBird.

Received on Wed Jun 25 2008 - 09:34:39 CDT

Original text of this message