Scenario

A patients address is stored natively in an XML document in the health care provider application. When a patient changes his address, the corresponding XML document needs to be updated into the application.

Operation

An UPDATE statement can be used on the XML column. patient_details table will be updated with the new address accordingly. Function XMLPARSE is used here to convert the document text into XML value so that it comply to the ADDRESS column XML type.

Solution

The health care provider uses the statement shown on the right pane to update a patients address which is stored in XML format.

Best Practices