Example 10-14: Nested DBXML query results for the patient table

<?xml version="1.0" ?>
<!-- Oracle DBXML Version 1.1.10 Query Results at 20-JUN-2000 22:27:22 -->
<!--
SELECT *
from patient
where id = 2099344
-->
<PATIENTLIST>
  <PATIENT>
    <ID>2099344</ID>
    <FIRSTNAME>Laurel</FIRSTNAME>
    <LASTNAME>Birch</LASTNAME>
    <VISITLIST>
      <VISIT>
        <ID>198554</ID>
        <VISITDATE>05-JUL-99</VISITDATE>
        <PATIENTID>2099344</PATIENTID>
        <FACILITYID>Bay03</FACILITYID>
        <DOCTORID>bproto</DOCTORID>
        <DOCTOR>
          <ID>bproto</ID>
          <FIRSTNAME>Bryan</FIRSTNAME>
          <LASTNAME>Proto</LASTNAME>
          <HOMEOFFICE>French44</HOMEOFFICE>
        </DOCTOR>
      </VISIT>
      <VISIT>
        <ID>197111</ID>
        <VISITDATE>24-JUN-99</VISITDATE>
        <PATIENTID>2099344</PATIENTID>
        <FACILITYID>French44</FACILITYID>
        <DOCTORID>bproto</DOCTORID>
        <DOCTOR>
          <ID>bproto</ID>
          <FIRSTNAME>Bryan</FIRSTNAME>
          <LASTNAME>Proto</LASTNAME>
          <HOMEOFFICE>French44</HOMEOFFICE>
        </DOCTOR>
      </VISIT>
      <VISIT>
        <ID>196223</ID>
        <VISITDATE>11-JUN-99</VISITDATE>
        <PATIENTID>2099344</PATIENTID>
        <FACILITYID>Bay03</FACILITYID>
        <DOCTORID>krhymes</DOCTORID>
        <DOCTOR>
          <ID>krhymes</ID>
          <FIRSTNAME>Kathryn</FIRSTNAME>
          <LASTNAME>Rhymes</LASTNAME>
          <HOMEOFFICE>Bay03</HOMEOFFICE>
        </DOCTOR>
      </VISIT>
    </VISITLIST>
  </PATIENT>
</PATIENTLIST>