On May 1, 3:16 pm, Tao <gordon.t..._at_gmail.com> wrote:
> 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.
http://www.williamrobertson.net/documents/one_row.html
Received on Wed May 02 2007 - 04:02:02 CDT
