I am using oracle built in wm_concat function for couple of columns in a query. It outputs data in single line.
my query looks like
select s,w(c) as c,w(a) as a from tbl where c in('zzz','yyy','xxx','uuu','vv') group by s
But i need to ascend or descend the data. How can i achieve it. Any ideas, resources, sample code highly appreciated thanks in advance