dbTalk Databases Forums  

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

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit

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


Discuss Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit in the comp.databases.oracle.misc forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
Norbert Winkler
 
Posts: n/a

Default Exists a aggregate function (Oracle9) for varchar that generate a comma separated lsit - 06-25-2008 , 09:34 AM





Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.


--
Norbert

Reply With Quote
  #2  
Old   
Terry Dykstra
 
Posts: n/a

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





"Norbert Winkler" <norbert.winkler1 (AT) gmx (DOT) de> wrote

Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.


--
Norbert
Other databases like SQLAnywhere have a list() function, but Oracle doesn't.
Do a google search on 'oracle list function' and you can find examples of
user defined functions.
--
Terry Dykstra




Reply With Quote
  #3  
Old   
Terry Dykstra
 
Posts: n/a

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


"Norbert Winkler" <norbert.winkler1 (AT) gmx (DOT) de> wrote

Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.


--
Norbert
Other databases like SQLAnywhere have a list() function, but Oracle doesn't.
Do a google search on 'oracle list function' and you can find examples of
user defined functions.
--
Terry Dykstra




Reply With Quote
  #4  
Old   
Terry Dykstra
 
Posts: n/a

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


"Norbert Winkler" <norbert.winkler1 (AT) gmx (DOT) de> wrote

Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.


--
Norbert
Other databases like SQLAnywhere have a list() function, but Oracle doesn't.
Do a google search on 'oracle list function' and you can find examples of
user defined functions.
--
Terry Dykstra




Reply With Quote
  #5  
Old   
Terry Dykstra
 
Posts: n/a

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


"Norbert Winkler" <norbert.winkler1 (AT) gmx (DOT) de> wrote

Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.


--
Norbert
Other databases like SQLAnywhere have a list() function, but Oracle doesn't.
Do a google search on 'oracle list function' and you can find examples of
user defined functions.
--
Terry Dykstra




Reply With Quote
  #6  
Old   
Carlos
 
Posts: n/a

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


On 25 jun, 16:34, Norbert Winkler <norbert.winkl... (AT) gmx (DOT) de> wrote:
Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.

--
Norbert
You may take a look here

http://carlosal.wordpress.com/2007/0...ets-a-cadenas/

It's only SQL, but I like it!

HTH.

Cheers.

Carlos.


Reply With Quote
  #7  
Old   
Carlos
 
Posts: n/a

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


On 25 jun, 16:34, Norbert Winkler <norbert.winkl... (AT) gmx (DOT) de> wrote:
Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.

--
Norbert
You may take a look here

http://carlosal.wordpress.com/2007/0...ets-a-cadenas/

It's only SQL, but I like it!

HTH.

Cheers.

Carlos.


Reply With Quote
  #8  
Old   
Carlos
 
Posts: n/a

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


On 25 jun, 16:34, Norbert Winkler <norbert.winkl... (AT) gmx (DOT) de> wrote:
Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.

--
Norbert
You may take a look here

http://carlosal.wordpress.com/2007/0...ets-a-cadenas/

It's only SQL, but I like it!

HTH.

Cheers.

Carlos.


Reply With Quote
  #9  
Old   
Carlos
 
Posts: n/a

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


On 25 jun, 16:34, Norbert Winkler <norbert.winkl... (AT) gmx (DOT) de> wrote:
Quote:
Hello,

The Firebird-Database 2.1 contains a LIST function

http://www.firebirdsql.org/rlsnotes/...leaseNotes.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.

--
Norbert
You may take a look here

http://carlosal.wordpress.com/2007/0...ets-a-cadenas/

It's only SQL, but I like it!

HTH.

Cheers.

Carlos.


Reply With Quote
  #10  
Old   
Mark D Powell
 
Posts: n/a

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


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


Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top