Hi,
I have got a new requirement to combine data in rows to a single row. So I thought of using LISTAGG() function and achieve it.
But while using it, There is a limitation as it returns data in varchar and at max we can get only 4000 characters.
So I decided to write a function on my own so that I can give the return type as CLOB.
But while implementation I have few doubts in the way LISTAGG is handing data.
Can anyone suggest me where I can find the code for LISTAGG function so that I can use it as reference Or someone can share over reply?
Thanks
Sandeep