Re: Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit
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