This content has been marked as final. Show 2 replies
Try this and let me know.
Evaluate_Aggr('XMLAGG(XMLELEMENT(%1,%2) order by %3).extract(%4)',col1,col2||'; ',col2,'//text()')
you might need to change the col1 col2 to match your db columns.
Note: Your Database should be 11g to work this out.
Edited by: Voltaire on Nov 13, 2012 2:06 PM