Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Parsing Oracle PIVOT XML data

by tweetiepooh (Hermit)
on Jan 15, 2016 at 16:01 UTC ( #1152861=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    select * from (
    select f1,f2,t from table where date > sysdate - 2
    )
    ...
    count(t) as al, sum(t) as ev
    for f2 in (any)
    )
    
  2. or download this
    f1
    --
    ...
    99999
    <PivotSet><item><column name = "F2">0</column><column name = "AL">12</
    +c
    olumn><column name = "EV">169</column></item></PivotSet>
    
  3. or download this
    varnn = {
        'f1' = '99999'.
        'f2_xml' = []
        };
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1152861]
Approved by Paladin
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (7)
As of 2022-11-29 15:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Notices?