Category: Howto

September 12

There has been a lot said and written about the Oracle ACE issue. Howards “Devalued” and “Revalued” posts, triggered a lot of emotions and commented visions and I think that this is the way it should be. Don’t say that there isn’t an active blogoshere. I saw one. I read a lot of stuff about what the community is doing and what we think it should be.

As I, indeed, said to Doug, getting / being passionate is part of the deal. I think this is the minimum an “ACE” should confirm to. You like it or you don’t (the Oracle stuff out there), or at least you are passionate about it.

August 28

Sometimes I forget the stuff I have learned… And sometimes someone, I am lucky enough (in this case on the OTN XMLDB Forum), is so friendly to point out how silly I am 😉

Last Friday I was testing Binary XMLType Tables in combination with use of an XMLIndex; Both using / being based on an XML Schema. The objects both used namespace references to the, for binary use, registered XML Schema. Whatever I did, it didn’t react as was described in the manuals.

It doesn’t help, that I know now that I should have been more observing to see what XMLSpy had generated as an example XML Instance document, nor the fact that I pinpointed to much on syntax and storage statements.

Luckily, in my mind, always conspicuous on stuff related to namespaces, I was so “smart” to not create a Oracle Support Request, but addressed it via the XMLDB OTN Forum… I was very embarrassed to read about (and afterwards had a good laugh about my mistake) as “Chandra” showed me my failure to see the simplest mistake…

August 28

In this post I wanted to share some methods you can use while manipulating XML data. My XMLType Table example is based on my last posts about XMLIndex and (binary) XML Storage. So if you want some more information I suggest reading up on those as well.

Triggered by a great example from Jonathan Gennick (“Faster, Safer, and Smaller LOBs”) in the September issue of Oracle Magazine.

I used this as a base, manipulating XMLType tables and see what happens if I would do the same, but now on XML objects.