Hi fellow monks
I am trying to execute the below query
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)
)
using DBI. The query in SQLPlus runs fine and I get no errors in Perl. f1 returns fine but the xml portion seems to be an empty array. I am using fetchall_hashref.SQLPlus output
f1
--
f2_xml
--------------------------------------------
99999
<PivotSet><item><column name = "F2">0</column><column name = "AL">12</
+c
olumn><column name = "EV">169</column></item></PivotSet>
Using Data::Dumper I see data like
varnn = {
'f1' = '99999'.
'f2_xml' = []
};
It's how I get to f2_xml I need a little help with.
Thanks
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|