>>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.

Indeed, it does. LISTAGG.