http://qs1969.pair.com?node_id=1153028


in reply to Re^2: Parsing Oracle PIVOT XML data
in thread Parsing Oracle PIVOT XML data

A work around might be to use a temporary table

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();
poj