Re: String concatenation in group by?

Micel,

I believe I've mentioned that I'm still using Oracle 9.2 so 10g's "collect" function is of no use to me.
Yes I understand any string manipulation can be done using PL/SQL functions, thanks.

On May 1, 10:57 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Tao" <gordon.t..._at_gmail.com> a écrit dans le message de news: 1178028983.392635.62..._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 - 10:01:58 CDT