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();
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Parsing Oracle PIVOT XML data
by tweetiepooh (Hermit) on Jan 19, 2016 at 10:32 UTC | |
by Corion (Patriarch) on Jan 19, 2016 at 11:37 UTC |
In Section
Seekers of Perl Wisdom