This content has been marked as final. Show 2 replies
Try with EVALUATE_AGGR function ex:1 person found this helpful
cast(EVALUATE_AGGR('LISTAGG(%1,%2) WITHIN GROUP (ORDER BY %3 DESC)',"Employee",',',"Employee") as char(50))
Hi,1 person found this helpful
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