Scenario

The health care provider generates a report at the end of the day to get a complete medical details of all the patients, their doctors, and few other information. The reports allow the doctors to quickly identify if further medical advice is necessary.

Operation

The SQL/XML function XMLTABLE displays XML data in the relational format after XQuery expressions are evaluated.

Solution

The patient information which is stored in XML with medical history is extracted into a report. It can then be used for further treatment to the patient.

Best Practices

Use SQL/XML Functions if