title: How to Add and Remove xml tags of existing data inside xmltype column in oracle
body: <p>I have created the following table:
  <a href="https://i.stack.imgur.com/bKZoh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bKZoh.png" alt="enter image description here"></a></p>
  
  <p>Here is 1 data row sample:</p>
  
  <p><a href="https://i.stack.imgur.com/xH7KK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xH7KK.png" alt="enter image description here"></a></p>
  
  <p>Inside this table, at column <code>SALPROFILE</code>, each column data contains a big xml data like following sample:</p>
  
  <pre><code>&lt;employee&gt;
    &lt;id&gt;FMCSC00015&lt;/id&gt;
    &lt;year&gt;2016&lt;/year&gt;
    &lt;month&gt;1&lt;/month&gt;
    &lt;PAYMSTR_SALHDNM&gt;BASIC PAY&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;35600&lt;/PAYMSTR_AMOUNT&gt;
    &lt;PAYMSTR_SALHDNM&gt;ASSOCIATION SUBSCRIPTION&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;240&lt;/PAYMSTR_AMOUNT&gt;
    &lt;PAYMSTR_SALHDNM&gt;TELEPHONE ALLOWANCE&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;800&lt;/PAYMSTR_AMOUNT&gt;
    &lt;PAYMSTR_SALHDNM&gt;HOUSE RENT DEDUCTION&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;2587.5&lt;/PAYMSTR_AMOUNT&gt;
    &lt;PAYMSTR_SALHDNM&gt;MEDICAL ALLOWANCE&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;700&lt;/PAYMSTR_AMOUNT&gt;
    &lt;PAYMSTR_SALHDNM&gt;GAS BILL&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;450&lt;/PAYMSTR_AMOUNT&gt;  
    &lt;PAYMSTR_SALHDNM&gt;LIFE INSURANCE PREMIUM (D)&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;1718&lt;/PAYMSTR_AMOUNT&gt;  
  &lt;/employee&gt;
  </code></pre>
  
  <p>i want to Add and Remove xml tags from above sample.
  For example, i want to remove   </p>
  
  <pre><code>&lt;PAYMSTR_SALHDNM&gt;BASIC PAY&lt;/PAYMSTR_SALHDNM&gt;
        &lt;PAYMSTR_AMOUNT&gt;35600&lt;/PAYMSTR_AMOUNT&gt;
  </code></pre>
  
  <p>and i want to add</p>
  
  <pre><code> &lt;PAYMSTR_SALHDNM&gt;BANK LOAN&lt;/PAYMSTR_SALHDNM&gt;
    &lt;PAYMSTR_AMOUNT&gt;23490&lt;/PAYMSTR_AMOUNT&gt;
  </code></pre>
  
  <p>How can i do this.is this possible doing it without tracing the entire xml data to make it more faster.I saw that    <a href="https://docs.oracle.com/database/121/SQLRF/functions012.htm#SQLRF06201" rel="nofollow noreferrer">Appendchildxml function</a> deprecated</p>