| TABLE 1: XML Data Type Methods |
| query(XQuery) |
Used to retrieve XML documents or fragments. Executes the XQuery parameter specified in the method definition and returns an untyped XML document. |
| value(XQuery, SQL type) |
Used to retrieve a scalar value from an XML document. Executes the XQuery and returns the selected value with the SQL type you specified. |
| exist(XQuery) |
Returns TRUE if the XQuery returns a nonempty result, FALSE if it returns an empty result, or NULL if the variable or column is NULL. |
| modify(XML_DML) |
Executes the XML_DML parameter to update the XML document. |