Category: 11gR1, 11gR2
May 14

XML Posts After One Year

I once started this website because of the steep learning curve regarding XMLDB functionality. After one year of existence the following posts were written by mean , for me as a notepad to remember what I have learned and or checked, tested or figured out and to pass it on to all those who are interested in XMLDB functionality as well.

I hope these posts, this list provided here, will be of help, to make those first steps or help designing a working and performing XMLDB environment. There is still a lot to describe and learn and hopefully I have time to cover these in the second year to come.

Have fun reading.

😎

Read the postXML Posts After One Year
April 15

Moving the DIAG directory

March 19

Using XMLDIFF for Database Change Management

I was triggered by a presentation of Dominic Delmolino during Hotsos 2008. He demonstrated a cool way of applying DDL database change management while making use of the Oracle database audit functionality. I combined the idea with Laurent Schneiders “out of the XML box thinking“, like for instance, his alternative use of the XMLTABLE syntax creating a pivot table. So why not do it the same way, solving “relational” problems, via XML functionality.

As said, the idea came up during Dominic Delmolino Hotsos presentation. Since Oracle 11g, the XMLDB functionality has a build in function called XMLDIFF. In Oracle 10 only a Java and C API exists, but probably could be used in the same way as described here. The XMLDIFF function compares two XML documents and captures the differences in XML conforming to an Xdiff schema. The diff document is returned as an XMLType document. Playing with Dominico’s idea, I thought, why not try to use the DBMS_METADATA.GET_XML function, transform this to an XMLType and then process it via XMLDIFF, and see if this can be useful for database change management purposes. So I tried.

So here it goes.

An example script can be downloaded here

Read the postUsing XMLDIFF for Database Change Management