select f1, xmltype.getclobval(f2_xml) as f2_xml from ( select * from ( select f1,f2,t from table where date > sysdate - 2 ) pivot xml ( count(t) as al, sum(t) as ev for f2 in (any) ) )