title: Parsing XML in an Oracle function
body: <p>I have a very simple XML document that is stored as a VARCHAR2 in an Oracle 10g table.  Below is an example of the XML.  I want to take the XML and insert it into a global temp table as a single record.  I've seen a couple other questions related to this topic but they were a little mor complex than I need.  Anyone show me how to grab the data out of this XML?  Thanks</p>
  
  <pre><code>&lt;Document&gt;
    &lt;A1&gt;
      &lt;D1&gt;dzzz&lt;/D1&gt;
      &lt;P1&gt;pzzz&lt;/P1&gt;
      &lt;AA1&gt;abcd&lt;/AA1&gt;
      &lt;PP1&gt;TEMP&lt;/PP1&gt;
      &lt;Desc&gt;TEMP DESC&lt;/Desc&gt;
      &lt;Price&gt;1.81568&lt;/Price&gt;
      &lt;Qty&gt;278&lt;/Qty&gt;
      &lt;Location&gt;E&lt;/Location&gt;
    &lt;/A1&gt;
  &lt;/Document&gt;
  </code></pre>