On the OTN XMLDB Forum, a question was asked if you could directly select from a XML file on disk, or to be more precise “XQUERY / XMLTABLE Syntax to read and XML from a Windows local drive?“. I had the idea that this could be easily done, nowadays via XMLDB functionality. So I tried it and came to the following conclusions. Although tested on Oracle 11.1.0.6.0 on Windows, this should also work on Oracle 10.2.x.
So as you can read here… It can be very easily done…
You probably know the feeling. Its Monday and you know what you have to do that week. On Friday you realize that the whole package shifted to the next week because you did got to it… That is what happened to me the last two weeks. Instead of cleaning up some duties, I was presented with such an amount of extra work that I didn’t come to it.
I wanted to write a decent post on the AMIS technology blog about how to “equipartition XML data making use of nested tables“. A feature that will see the light in 11.1.0.7.0, the first patch for Oracle 11g. Although my test scripting has finished, I just didn’t come to it. I wanted to do some research on the presented XMLTable Index introduced by one of Mark Drake’s presentation during Oracle Open World 2007. It had to wait as well. I had to do some work regarding setting up standards for AMIS concerning OFA complaint database VMware project environments and VMware Oracle Application Server environments. Alas…
Bad Behavior has blocked 320 access attempts in the last 7 days.