Just a small post here as a reminder how it can be applied: the use of namespaces in conjunction with the XMLQuery operator. A question came up on the OTN XMLDB Forum based on XMLQuery. After building a correct example XML file I needed the namespace reference within XMLQuery and it wasn’t easy to find so here, as a reminder, the comprised version.
See also post “Xquery Error – ORA19276” as a reference.