title: How to retrieve a specific XML node from an Oracle table?
body: <p>I have an oracle table which has a column that stores XML in a CLOB format. The XML has the following syntax:</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="ISO-8859-1" ?&gt; 
   &lt;BaseXML Version="2009.4"&gt;
   &lt;InvoiceCanvasDetails&gt;
       &lt;Grouping&gt;
         &lt;ParentGroup Name=”Parent group 1” ID=”100”&gt;
          &lt;ParentGroupLineItems&gt;
           &lt;Item ID="461616" Name=”Item 1”&gt;
             &lt;Papers Quantity=10000&gt;
                            &lt;Paper Name="UNCOATED GROUNDWOOD SCA+ (25X38)"    
                                        ID="126287" Weight="1268" Type=”A4” /&gt; 
                            &lt;Paper Name="COATED GROUNDWOOD SCA+ (25X38)"    
                                        ID="126288" Weight="1290" Type=”A4” /&gt;
                       &lt;/Papers&gt;
                &lt;/Item&gt;
         &lt;/ParentGroupLineItems&gt;
      &lt;/ParentGroup&gt;
    &lt;/Grouping&gt;
   &lt;/InvoiceCanvasDetails&gt;
  &lt;/BaseXML&gt;
  </code></pre>
  
  <p>Now, I want to retrieve only the Paper information corresponding to each item. ie, Given an item ID, retrieve all the papers associated to it using a query. Please guide me which is the  best way to do this.</p>