SQL & PL/SQL

Hi All,

I have table TEMP like below format.

CREATE TABLE TEMP(TEMP_ID VARCHAR2(100), A_SPEED VARCHAR2(100), L_INTER VARCHAR2(100))

My Query

========

SELECT DISTINCT TEMP_ID,

RTRIM(XMLAGG(XMLELEMENT(E,A_SPEED,',').EXTRACT('//text()') ORDER BY A_SPEED).GetClobVal(),',') AS "A_SPEED",

RTRIM(XMLAGG(XMLELEMENT(E,L_INTER,',').EXTRACT('//text()') ORDER BY L_INTER).GetClobVal(),',') AS "L_INTER"

FROM TEMP

GROUP BY TEMP_ID;

OUTPUT

=======

Required Output

=============

I need to remove duplicate values from my result of XMLAGG. I have around 50 columns to apply XMLAGG like this. I cant use LISTAGG or WM_CONTACT as it has limitation of 4000 characters.

Please help me in that. I am using Oracle 11g. Let me know if you need anything more info.

Thanks

11081985