title: XPath concat with EXTRACT function Oracle
body: <p>I want to extract the values of "KEY" and "VALUE" and concat these results using XPath with EXTRACT.</p>
  
  <p>Sample XML as below.</p>
  
  <pre><code>&lt;PivotSet&gt;
    &lt;item&gt;
      &lt;column name = "KEY"&gt;RET_1&lt;/column&gt;
      &lt;column name = "VALUE"&gt;A&lt;/column&gt;
    &lt;/item&gt;
    &lt;item&gt;
      &lt;column name = "KEY"&gt;RET_2&lt;/column&gt;
      &lt;column name = "VALUE"&gt;R&lt;/column&gt;
    &lt;/item&gt;
    &lt;item&gt;
      &lt;column name = "KEY"&gt;RET_3&lt;/column&gt;
      &lt;column name = "VALUE"&gt;P&lt;/column&gt;
    &lt;/item&gt;
  &lt;/PivotSet&gt;
  </code></pre>
  
  <p>I need to return in SQL something like</p>
  
  <pre><code>RET_1@A;RET_2@R;RET_3@P
  </code></pre>
  
  <p>where the delimiter '@' separates the key/value and ':' separates the items. I want to do it with EXTRACT and XPath.</p>