Database Reference
In-Depth Information
Figure 17.3
Applying a Style
Sheet to an XML
Document.
we want to do with XML documents in Oracle SQL, without digging up
too much detail?
Create XML documents.
Store and retrieve XML documents.
Add to, make changes in, and destroy XML documents.
17.2.1
Creating XML Documents
The obvious first step is to look at the XMLType datatype.
17.2.1.1
The XMLType Datatype
The XMLType datatype is a special datatype for storing XML documents.
An XMLType can be stored in a specially built table, in a column in a table,
or in something like a CLOB object. Note that even for a table or a col-
umn, the default storage mode for an XMLType datatype is a CLOB object.
So, for example, we could create a table as being of XMLType datatype.
