title: XMLType pl/sql add child
body: <p>I have problem with correct adding childs from pl/sql into xml structure like as below.</p>
  
  <pre><code>  &lt;DATA&gt;
    &lt;CHILDRENS&gt;
      &lt;CHILDRENS_DEF lname="smith"&gt;
        &lt;CHILD_KOL no="1" name="Id" desc="Id" typ="NUMBER"/&gt;
        &lt;CHILD_KOL no="2" name="Fname" desc="Fname" typ="VARCHAR2"/&gt;
      &lt;/CHILDRENS_DEF&gt;
      &lt;CHILDRENS_DATA&gt;
        &lt;CHILD_DATA no="1"&gt;
          &lt;CHILD_COL_VALUE no="1" name="Id"&gt;1&lt;/CHILD_COL_VALUE&gt;
          &lt;CHILD_COL_VALUE no="2" name="Fname"&gt;Christopher&lt;/CHILD_COL_VALUE&gt;
        &lt;/CHILD_DATA&gt;
        &lt;CHILD_DATA no="2"&gt;
          &lt;CHILD_COL_VALUE no="1" name="Id"&gt;1&lt;/CHILD_COL_VALUE&gt;
          &lt;CHILD_COL_VALUE no="2" name="Fname"&gt;Alice&lt;/CHILD_COL_VALUE&gt;
        &lt;/CHILD_DATA&gt;
        &lt;CHILD_DATA no="3"&gt;
          &lt;CHILD_COL_VALUE no="1" name="Id"&gt;1&lt;/CHILD_COL_VALUE&gt;
          &lt;CHILD_COL_VALUE no="2" name="Fname"&gt;John&lt;/CHILD_COL_VALUE&gt;
        &lt;/CHILD_DATA&gt;
      &lt;/CHILDRENS_DATA&gt;
    &lt;/CHILDRENS&gt;
    &lt;CHILDRENS&gt;
      &lt;CHILDRENS_DEF lname="mushroom"&gt;
        &lt;CHILD_KOL no="1" name="Id" desc="Id" typ="NUMBER"/&gt;
        &lt;CHILD_KOL no="2" name="Fname" desc="Fname" typ="VARCHAR2"/&gt;
      &lt;/CHILDRENS_DEF&gt;
      &lt;CHILDRENS_DATA&gt;
        &lt;CHILD_DATA no="1"&gt;
          &lt;CHILD_COL_VALUE no="1" name="Id"&gt;1&lt;/CHILD_COL_VALUE&gt;
          &lt;CHILD_COL_VALUE no="2" name="Fname"&gt;Arthur&lt;/CHILD_COL_VALUE&gt;
        &lt;/CHILD_DATA&gt;
      &lt;/CHILDRENS_DATA&gt;
    &lt;/CHILDRENS&gt;
  &lt;/DATA&gt;
  </code></pre>
  
  <p>I want to add child to CHILDRENS where CHILDRENS_DEF = lname=mushroom.
  When I do something like that:</p>
  
  <pre><code>UPDATE xml_childrens
  SET  CLOBXMLCOL = INSERTCHILDXML(CLOBXMLCOL, 'DATA/CHILDRENS','CHILD_DATA', 
                  XMLType('&lt;CHILD_DATA no="2"&gt;
                              &lt;CHILD_COL_VALUE no="1" name="Id"&gt;2&lt;/CHILD_COL_VALUE&gt;
                              &lt;CHILD_COL_VALUE no="2" name="Fname"&gt;Adele&lt;/CHILD_COL_VALUE&gt;
                           &lt;/CHILD_DATA&gt;'))
  </code></pre>
  
  <p>I add new child for all families. How I can add CHILD_DATA only for lname=mushroom.
  Question no 2. How can I count CHILD_DATA for family?</p>