title: Delete xml node with a specific CDATA
body: <p>This is part of my XML:</p>
  <pre><code> &lt;EO Name=&quot;oracle.apps.hcm.goals.core.publicModel.entity.GoalMeasurementEO&quot;&gt;    
                      &lt;![CDATA[0001FFFFFFFF]]&gt;    
                      &lt;GoalMeasurementEORow PS=&quot;0&quot; Hdl=&quot;16&quot; PK=&quot;Y&quot; CI=&quot;Y&quot; AV=&quot;111111111111111111111111111111&quot;&gt;    
                         &lt;MeasurementId&gt;  
                            &lt;DATA null=&quot;true&quot;/&gt;   
                         &lt;/MeasurementId&gt; 
                      &lt;/GoalMeasurementEORow&gt; 
                   &lt;/EO&gt;  
      &lt;EO Name=&quot;oracle.apps.hcm.goals.core.publicModel.entity.GoalMeasurementEO&quot;&gt; 
                      &lt;![CDATA[00010000000EACED00057708000110D943311B2F]]&gt;    
                      &lt;GoalMeasurementEORow PS=&quot;0&quot; Hdl=&quot;1019&quot; PK=&quot;Y&quot; CI=&quot;Y&quot; AV=&quot;&quot;&gt;    
                         &lt;MeasurementId&gt;  
                            &lt;DATA&gt;300000297949999&lt;/DATA&gt;  
                         &lt;/MeasurementId&gt; 
                         &lt;BusinessGroupId&gt;    
                            &lt;DATA&gt;1&lt;/DATA&gt;    
                         &lt;/BusinessGroupId&gt;   
                       &lt;/EO&gt;
  </code></pre>
  <p>I need to delete the EO node with <code>&lt;![CDATA[0001FFFFFFFF]]&gt;</code>,across the table using Oracle. This xml is stored in XM_DATA_CACHE of XMLTYPE.
  Is there a way to delete based on CDATA</p>
  <p>Final output should be</p>
  <pre><code>&lt;EO Name=&quot;oracle.apps.hcm.goals.core.publicModel.entity.GoalMeasurementEO&quot;&gt; 
                      &lt;![CDATA[0001FFFFFFFF]]&gt;    
                      &lt;GoalMeasurementEORow PS=&quot;0&quot; Hdl=&quot;16&quot; PK=&quot;Y&quot; CI=&quot;Y&quot; AV=&quot;111111111111111111111111111111&quot;&gt;    
                         &lt;MeasurementId&gt;  
                            &lt;DATA null=&quot;true&quot;/&gt;   
                         &lt;/MeasurementId&gt; 
                      &lt;/GoalMeasurementEORow&gt; 
                   &lt;/EO&gt;  ```
  </code></pre>