SQL, XML/SQL, XPath, XQuery

There are cool posts out there regarding querying the OPatch info in Oracle 12 which…

So we concluded the post “Tuning Database XQuery Statements (1)” with the following SQL statement…

I had a question of a colleague to have a look at a statement that…

I wouldn’t believe the bad XMLType performance statement given stated in Martin Preiss’ blog post,…

Somewhere on this site is a post regarding how to validate against an XML schema…

DeleteXML, InsertXML, UpdateXML, appendChildXML, insertChildXML, insertchildXMLafter, insertChildXMLbefore, insertXMLafter and insertXMLbefore are dead (& deprecated) from…

Very often people want to load XML documents into an Oracle database so, for example, they can shred the needed values from those XML documents...
class="readmore">Read More

My goal was initially to concatenate all rows generated via the package DBMS_FEATURE_USAGE_REPORT in one big HTML (XML?) document instead of the by default generated...
class="readmore">Read More

Hereby a listing of XQuery, XPath pragma’s used in the Oracle (XMLDB) environment. The list is currently not ordered, and/or order by topic; this so...
class="readmore">Read More

New, new…? No, not really new, XQuery Update (W3C standard/draft 2011) was already implemented in 11.2.0.3.0, but is now officially also announced. Besides the XQuery Full Text support (XQFT for short, W3C standard/draft 2011), this is one of the big new features in Oracle 12c. With this update XQuery functionality, the XQuery standard is further

Read More...