Any built in function of string aggregation?

[Vinay Bhushan]

HI,

We tried to implement a requirement where we need to send notifications to users ina group. For fetching the to list, we have used a query which uses LISTAGG function to get mails comma separated. Since LISTAGG function has character limit of 4000 characters, the characters in the to list are nearly 7000. I would like to know if we can use any different Oracle function in the query to fetch all the 7000 characters.

Kindly provide your inputs.Would like to try.

Regards
Vinay

[Pratyush Prateek]

Try using XMLAGG instead.