Re: String concatenation in group by?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 1 May 2007 16:57:01 +0200
Message-ID: <4637553d$0$14547$426a34cc@news.free.fr>

"Tao" <gordon.t.wu_at_gmail.com> a écrit dans le message de news: 1178028983.392635.62470_at_n59g2000hsh.googlegroups.com...
| Hi,
|
| I'm wondering if its possible to perform concatenation of strings in
| "group by". I'm still using Oracle 9.2, so I cannot take advantage
| 10g's new "collect" aggregrate function.
|
| Here is an example table, tab_example:
|
| ID Name
| --- -----------
| 1 Hello
| 1 World
|
| My desired query result:
| ID Concatenated_Name
| --- ------------------------------
| 1 Hello World
|
|
| Thanks a lot.
|

I wonder why people always think they are the first one to ask for a question. <g>

I just put "oracle string aggregation" in Google and the first item returned (http://www.oracle-base.com/articles/10g/StringAggregationTechniques.php) gives 5 ways to do it.

Regards
Micel Cadot Received on Tue May 01 2007 - 09:57:01 CDT