Example 10-16: Nested DBXML query results for the state table

<?xml version="1.0" ?>
<!-- Oracle DBXML Version 1.1.10 Query Results at 20-JUN-2000 22:29:23 -->
<!--
SELECT *
  from state 
 where name = 'CA'
-->
<STATELIST>
  <STATE>
    <NAME>CA</NAME>
    <COUNTRYNAME>USA</COUNTRYNAME>
    <CITYLIST>
      <CITY>
        <NAME>San Francisco</NAME>
        <STATENAME>CA</STATENAME>
        <FACILITYLIST>
          <FACILITY>
            <CODE>Bay03</CODE>
            <NAME>Bayside Medical</NAME>
            <ADDRESS>201 Oceanview Rd.</ADDRESS>
            <CITY>San Francisco</CITY>
          </FACILITY>
          <FACILITY>
            <CODE>French44</CODE>
            <NAME>Downtown French Campus</NAME>
            <ADDRESS>11 Battery Street</ADDRESS>
            <CITY>San Francisco</CITY>
          </FACILITY>
        </FACILITYLIST>
      </CITY>
      <CITY>
        <NAME>Oakland</NAME>
        <STATENAME>CA</STATENAME>
        <FACILITYLIST>
        </FACILITYLIST>
      </CITY>
      <CITY>
        <NAME>Los Angeles</NAME>
        <STATENAME>CA</STATENAME>
        <FACILITYLIST>
        </FACILITYLIST>
      </CITY>
    </CITYLIST>
  </STATE>
</STATELIST>