>Hello Naomi
>
>can I use same query in Oracle ?
>
>Thank You.
>
>Best Regards,
>Mazahir Naya
I don't think so. I don't think FOR XML PATH('') is going to work in Oracle. Most likely Oracle has its own group_concat function.
If it's not broken, fix it until it is.
My Blog