6.2. Storing XML as CLOB
In this section we discuss how to store XML as a CLOB.
6.2.1. Using CLOB and the OracleText Cartridge
The simplest approach for handling XML documents is to use relational tables with one or more CLOB columns, supplemented by structured information that classifies and characterizes the documents. Using relational concepts, the XML documents can thus be organized in the sense of containers as provided by native XML databases. However, storing and retrieving documents is only possible as a whole. In fact, updates of XML repositories are still a fundamental research issue for which Oracle has no solution as yet.
In Oracle there is principally no difference between CLOBs and strings except that a CLOB can hold up to 4GB. ...
Get XML Data Management: Native XML and XML-Enabled Database Systems 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.
