title: oracle plsql: how to parse XML and insert into table
body: <p>How to load a nested xml file into database table ?</p>
  
  <pre><code>&lt;?xml version="1.0" ?&gt; 
  &lt;person&gt;
     &lt;row&gt;
         &lt;name&gt;Tom&lt;/name&gt;
         &lt;Address&gt;
             &lt;State&gt;California&lt;/State&gt;
             &lt;City&gt;Los angeles&lt;/City&gt;
         &lt;/Address&gt;
     &lt;/row&gt;
     &lt;row&gt;
         &lt;name&gt;Jim&lt;/name&gt;
         &lt;Address&gt;
             &lt;State&gt;California&lt;/State&gt;
             &lt;City&gt;Los angeles&lt;/City&gt;
         &lt;/Address&gt;
     &lt;/row&gt;
  &lt;/person&gt;       
  </code></pre>
  
  <p>In this xml, person is the table name , name is the filed name, Tom is its filed value. 
  Address is a subtable and state and city is two column inside Address. I want to insert the person row into person table, if it failed , do not insert into address table. This xml could be very big. What's the best solution to do this ? </p>