We don't bite newbies here... much | |
PerlMonks |
Re: Parsing Oracle PIVOT XML databy Anonymous Monk |
on Jul 27, 2018 at 16:14 UTC ( [id://1219388]=note: print w/replies, xml ) | Need Help?? |
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)
)
)
In Section
Seekers of Perl Wisdom
|
|