>>>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.
I'd be careful with any of those features (FOR XML PATH, LISTAGG, etc.) over large sets of rows. FOR XML PATH is a great feature, but it doesn't perform well on large tables. So always good to test.
But for tables in the range of a few thousand rows, it works great.