The format and data of XML purchase orders are well suited for Oracle XML DB storage and processing techniques because purchase orders are highly structured XML documents.
However, the majority of techniques introduced here can also be used to manage other types of XML documents, such as containing unstructured or semistructured data.
XML developers can leverage the power of XML standards while working in the context of a relational database.
Table 3-1 summarizes some advantages and disadvantages to consider when selecting your Oracle XML DB storage option.
It is equivalent to the IANA registered standard UTF-8 encoding, which supports all valid XML characters.
Do not confuse Oracle Database database character set UTF8 (no hyphen) with database character set AL32UTF8 or with character use UTF8 for XML data.
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases?
The XML Schema Recommendation is described at: is often used to describe an XML document that conforms to a given XML schema.
The most common use of an XML schema is to validate that a given instance document conforms to the rules defined by the XML schema.
This chapter also further explains Oracle XML DB concepts introduced in Chapter 1, "Introduction to Oracle XML DB".
This chapter contains these topics: , SQL developers can leverage the power of the relational database while working in the context of XML.
To load an XML document into the repository under a given path, use PL/SQL package Many operations for configuring and using Oracle XML DB are based on processing one or more XML documents – for example, registering an XML schema and performing an XSL transformation.