XML

The maximum size is 2 GB minus 1 byte (2³¹ - 1).

Data of type XML is not quoted when generating element content from relational data.

You can cast between the XML data type and any other data type that can be cast to or from a string. Note that there is no checking that the string is well-formed when it is cast to XML.

When an embedded SQL client application performs a DESCRIBE on an XML column, it is described as LONG VARCHAR.

• Use of XML in the database
• Storage of XML documents in relational databases