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

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 25 Jun 2008 11:40:06 -0700 (PDT)
Message-ID: <b042cb94-12aa-4bf4-b0ca-a9a4bd8e14cf@y38g2000hsy.googlegroups.com>


On Jun 25, 2:24†pm, Krzysztof Jamrůz <SpAMkrzyh000J..._at_ZLYo2.pl> wrote:
> 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

Also of possible interest on the topic of creating or extracting comma delimted lists would be the dbms_utility.table_to_comma and comma_to_table procedures for unloading and loading pl/sql tables (arrays).

HTH -- Mark D Powell -- Received on Wed Jun 25 2008 - 13:40:06 CDT

Original text of this message