String concatenation in group by?

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. Received on Tue May 01 2007 - 09:16:23 CDT