Scenario
The health care provider needs to find all the patients who had treated by a doctor Durenda. Doctor's informaion and reports are stored in the PMD documents in XML format.
Operation
The XMLEXISTS predicate checks for the condition specified and returns a boolean accordingly. The example on the right shows that XMLEXISTS returns 'true' if the doctor's given name is 'Durenda' and 'false' if otherwise.
Solution
Patients treated by doctor Durenda are returned.
Best Practices