Re: String concatenation in group by?

Comments embedded.
On May 1, 10:01 am, Tao <gordon.t..._at_gmail.com> wrote:
> 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.

So be intelligent enough to not consider that 'option' and proceed on to the other four.

> Yes I understand any string manipulation can be done using PL/SQL
> functions, thanks.
>

And, yet, there is a non-PL/SQL option available you apparently choose to overlook. Instead of disparaging suggestions made to you why not accept them graciously and evaluate them on their merits?

> 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- Hide quoted text -
>
> - Show quoted text -

David Fitzjarrell Received on Tue May 01 2007 - 10:57:40 CDT