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

#11

On Jun 25, 2:24*pm, Krzysztof Jamróz <SpAMkrzyh000J... (AT) ZLYo2 (DOT) pl>
wrote:

Quote:

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 --

#12

On Jun 25, 2:24*pm, Krzysztof Jamróz <SpAMkrzyh000J... (AT) ZLYo2 (DOT) pl>
wrote:

Quote:

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 --

#13

On Jun 25, 2:24*pm, Krzysztof Jamróz <SpAMkrzyh000J... (AT) ZLYo2 (DOT) pl>
wrote:

Quote:

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 --

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Exists a aggregate function (Oracle9) for varchar that generate acomma separated lsit - 06-25-2008 , 01:40 PM

Re: Exists a aggregate function (Oracle9) for varchar that generate acomma separated lsit - 06-25-2008 , 01:40 PM

Re: Exists a aggregate function (Oracle9) for varchar that generate acomma separated lsit - 06-25-2008 , 01:40 PM