Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^5: Parsing Oracle PIVOT XML data

by Corion (Patriarch)
on Jan 19, 2016 at 11:37 UTC ( #1153081=note: print w/replies, xml ) Need Help??


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

I would assume that creating temporary tables is possible even if the user lacks the permissions to create (permanent) tables:

CREATE GLOBAL TEMPORARY TABLE my_temp_table (...) ON COMMIT DELETE ROWS;

As to the larger issue, I think it's mainly an issue of the DBD to return the structured data from the XML query, and maybe supporting that isn't that easy without the driver becoming "locked" to a specific version of Oracle.

Log In?
Username:
Password:

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

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