What Is Oracle XML DB?

Oracle introduced Oracle XML DB as part of Oracle9iR2. Oracle XML DB is a built-in component inside the Oracle database, which extends the Oracle database’s relational storage by adding XMLType, a new native XML storage type. XMLType becomes the fundamental component in Oracle XML DB for XML storage, retrieval, and processing.

XMLType simplifies the XML storage, retrieval, and processing in the Oracle database. Without native XML storage, XML documents have to be either “shredded” to store in multiple relational tables and then render XML as the output, or store XML intact as large text/binary objects in CLOBs or BLOBs. XML’s hierarchical data structure normally doesn’t work well with the relational table-row format. Storing ...

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.