This section shows a sample XML document, depts.xml, which illustrates an application of xmltable().

<sample>
<depts>
   <dept>
	<dept_id>D123</dept_id>
	<dept_name>Main</dept_name>
   <emps>
    <emp>
	<emp_id>E123</emp_id>
	<emp_name>Alex Allen</emp_name>
	<salary>912.34</salary>
	<phones>
          <phone><phone_no>510.555.1987</phone_no></phone>
          <phone><phone_no>510.555.1867</phone_no></phone>
	</phones>
    </emp>
   <emp>
	<emp_id>E234</emp_id>
	<emp_name>Bruce Baker</emp_name>
	<salary>923.45</salary>
	<phones>
        <phone><phone_no>230.555.2333</phone_no></phone>
	  </phones>
  </emp>
   <emp>
	<emp_id>E345</emp_id>
	<emp_name>Carl Curtis</emp_name>
	<salary>934.56</salary>
	<phones>
         <phone><phone_no>408.555.3123</phone_no></phone>
         <phone><phone_no>415.555.3987</phone_no></phone>
        <phone><phone_no>650.555.3777</phone_no></phone>
       </phones>
   </emp>
  </emps>
<emps_summary>
<salary_summary>
	<max_salary>934.56</max_salary>
	<total_salary>2770.35</total_salary>
</salary_summary>
</emps_summary>
<projects>
<project>
   <project_id>PABC</project_id>
   <budget>598.65</budget>
</project>

<project>
   <project_id>PBDC</project_id>
   <budget>587.65</budget>
</project>
<project>
   <project_id>PCDE</project_id>
   <budget>576.54</budget>
</project>

  </projects>
  <projects_summary>
 <budget_summary>
   <max_budget>598.76</max_budget>
   <total_budget>1762.95</total_budget>
 </budget_summary>
  </projects_summary>
</dept>
<dept>
	<dept_id>D234</dept_id>
	<dept_name>Auxiliary</dept_name>
   <emps>
    <emp>
	<emp_id>E345</emp_id>
	<emp_name>Don Davis</emp_name>
	<salary>945.67</salary>
	<phones>
     <phone><phone_no>650.555.5001</phone_no></phone>
	 </phones>
     <emp>
	<emp_id>E345</emp_id>
	<emp_name>Earl Evans</emp_name>
	<phones>
     <phone><phone_no>650.555.5001</phone_no></phone>
	 </phones>

    </emp>
  </emps>
<emps_summary>
<salary_summary>
	<max_salary>945.67</max_salary>
	<total_salary>945.67</total_salary>
</salary_summary>

</emps_summary>
<projects>
 <project>

 <project>
   <project_id>PDEF</project_id>
< /project>
 <project>
   <project_id>PEFG</project_id>
   <budget>554.32</budget>
</project>
  </project>
  </projects>
  <projects_summary>
 <budget_summary>
   <max_budget>554.32</max_budget>
   <total_budget>554.32</total_budget>
 </budget_summary>
  </projects_summary>
</dept>
</dept>
<dept>
	<dept_id>D345</dept_id>
	<dept_name>Repair</dept_name>
   <emps>
    <emp>
	<emp_id>E678</emp_id>
	<emp_name>Fred Frank</emp_name>
	<salary>967.89</salary>
	<phones>
          <phone><phone_no>408.555.6111</phone_no></phone>
	  </phones>
   </emp
   <emp>>
	<emp_id>E789</emp_id>
	<emp_name>George Gordon</emp_name>
	<salary>978.90</salary>
	<phones>
     <phone><phone_no>510.555.7654</phone_no></phone>
	 </phones>
   </emp>
   <emp>
	<emp_id>E901</emp_id>
	<emp_name>Hank Hartley</emp_name>
	<salary>990.12</salary>
	<phones\>
   </emp
   <emp>
	<emp_id>E678</emp_id>
	<emp_name>Isaak Idle</emp_name>
	<salary>990.12</salary>
	<phones>
        <phone><phone_no>925.555.9991</phone_no></phone>
        <phone><phone_no>650.555.9992</phone_no></phone>
        <phone><phone_no>415.555.9993</phone_no></phone>
	 </phones>
   </emp>
	<emps>
	<emps_summary>
   <salary_summary>
	<max_salary>990.12</max_salary>
	<total_salary>2936.91</total_salary>
  </salary_summary>
  </emps_summary>
  <projects>
    <project>
      <project_id>PFGH</project_id>
      <budget>543.21</budget>
   </project>
   <project>
    <project_id>PGHI</project_id>
   </project>
   <project>
     <project_id>PHIJ</project_id>
     <budget>521.09</budget>
   </project>
   </project>
 </projects>
  <projects_summary>
 <budget_summary>
   <max_budget>543.21</max_budget>
   <total_budget>1064.30</total_budget>
 </budget_summary>
  </projects_summary>
</dept>
</depts>
</sample>