Hi Mazahir,

In the case you must write own function which will be emulate LISTAGG().

MartinaJ

>hi Martina
>
>Thanks for the reply but my oracle version is 10 and this LISTAGG not supported for 10g is there any other way to do it.
>
>Best Regards
>Mazahir Naya