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
pojmy $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();
In Section
Seekers of Perl Wisdom