Querying XML DB Repository

To query XML DB Repository in SQL, we need to clarify the two key elements in XML DB Repository—resource and path:

Image  Resource Each document or folder in XML DB Repository is represented as a resource. A resource normally includes a resource name, a description, and the resource content. A file resource can be XML or non-XML documents, or even XML views. The XML resources are stored in XMLTypes. Non-XML resources are stored in BLOB. You can find a more detailed description of the XML DB resources in the /sys/schemas/PUBLIC/xmlns.oracle.com/xdb/XDBResource.xsd file.

  Path A link which represents the location of a resource ...

Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.