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.