Re: String concatenation in group by?

<gordon_t_wu_at_hotmail.com> a écrit dans le message de news: 1178210236.450528.155040_at_p77g2000hsh.googlegroups.com... 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"aggregratefunction.
> |
> | 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

Well when you already know the solution, its easy to find it. For people who do not already know, its not so easy for them to put the right key words in google. Apparently he did search for solutions before coming here, which is exactly what this group is for. No reason to insult people while providing an answer.

I don't see any clue he searched hard as he only got a way. I only used the words he used:
Oracle is this not Oracle he is working with "string aggregation", well the subject is "string concatenation in group by" so "group by" means aggregation, of what... of strings. So it is clearly obvious to use "oracle string aggregation", or at least to try it.

Btw, your and his email are the same ones, don't you are the same person? Is it in your way to talk about you at the third person?

Regards
Michel Cadot Received on Thu May 03 2007 - 12:05:08 CDT