what is xmlagg in oracle?
In Oracle PL/SQL, XMLAGG is a built in aggregate function which combines multiple XML elements together. The main use of XMLAGG function is concatenating multiple row values of a column into single row. Example Syntax: XMLAGG(XML Type instance (ORDER BY clause))