XMLAGG, XMLELEMENT - XML functions

Database
Enthusiast

XMLAGG, XMLELEMENT - XML functions

Hi Team,

I have a sql statement like below.

RTRIM(XMLAGG(XMLELEMENT (E, COL1|| ';') ORDER BY COL1).EXTRACT ('//TEXT()'), ';') AS COL_NAME

Can someone tell me the usage of XML functions and what above command does line by line.

Thanks,

-- AsCharan