note
poj
<p>A work around might be to use a temporary table</p>
<c>
my $sql = '
insert into TMP_XML value (
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)
)
)';
$dbh->do($sql);
my $sth = $dbh->prepare('SELECT * FROM TMP_XML');
$sth->execute();
</c>
poj
1152861
1153003