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