title: How to simple change node's attribute value of XMLTYPE in Oracle 11g r2?
body: <p>I just wanna to change in this XML (contained in XMLTYPE variable) all nodes named "ChildNode" with "Name"="B" attribute values to "C":</p>
  
  <pre><code>&lt;RootNode&gt;
    &lt;ChildNodes&gt;
      &lt;ChildNode Name="A"/&gt;
      &lt;ChildNode Name="B"/&gt;
    &lt;/ChildNodes&gt;
  &lt;/RootNode&gt;
  
  DECLARE
    FXML XMLTYPE;
  BEGIN
    FXML := ...; -- see text before
    -- what next?
  END;
  </code></pre>
  
  <p>Thanks!</p>