Category: Howto
August 17

HOWTO: Create XMLType Table for Binary XML Usage

Binary XML storage can also be combined with an XML Schema. As shown in Mark Drakes presentation whitepaper (slide 6), the lower right of the diagram, shown below, marks the section for XML Schema (structured, schema based) binary XML storage.

Slide 6 of “Oracle Database 11g XML DB Presentation (PDF) July 2007”

XML Use Cases - Oracle Database 11g XML DB Presentation (PDF) July 2007, Mark Drake, Oracle

Click picture to enlarge

The following example will show how you can create an XMLType table making use of a defined XML Schema and how to avoid the ORA-44424 error (BINARY XML storage requires XML Schema registered for BINARY usage).

Read the postHOWTO: Create XMLType Table for Binary XML Usage
July 10

Oracle 11g – XMLIndex (part 1)

The following is an extension on the former post about “About Table(XMLSequence()) and XMLTable”. These examples where based on a XMLType column using CLOB storage. If you have read the “Oracle 11g – XMLType Storage Options“, then you should now know that this storage model is only performing if you had a document centric environment in mind.

Oracle’s 11g addition “XMLIndex”, will give you an solution for these kinds of environments.

The XMLIndex is a domain index, specially crafted for use in a XMLDB environment. It is a logical index with 3 components (excerpt Oracle 11g beta XMLDB Developers Guide):

Read the postOracle 11g – XMLIndex (part 1)
July 10

About Table(XMLSequence()) and XMLTable

A customer asked me how this XMLTable XML function works… Until now they had to use the TABLE(XMLSEQUENCE()) constructor.

While testing performance differences between a RedHat AS V3 (Oracle Enterprise Version 10.1.0.3, RAID 1+0) machine and a full blown LPAR IBM AIX 64b 5.3 environment (Oracle Enterprise Version 10.2.0.2) with EMC (RAID 5) they wanted to use the XMLTABLE XML function.

Why? Oracle promotes the use of the XMLTable function on 10.2.x and higher Oracle versions. My belief is that the TABLE(XMLSEQUENCE()) constructor will be deprecated in favor of the XMLTABLE function. Also the XMLTABLE function supports XQuery functionality.

They had a simple statement to test with.

Read the postAbout Table(XMLSequence()) and XMLTable