title: Xpath with XMLTABLE
body: <p>Using this XML :</p>
  
  <pre><code>&lt;attrs&gt;
      &lt;attr multiple="true" name="LETTER"&gt;
          &lt;string&gt;A&lt;/string&gt;
          &lt;string&gt;B&lt;/string&gt;
          &lt;string&gt;C&lt;/string&gt;
          &lt;string&gt;D&lt;/string&gt;
      &lt;/attr&gt;
      &lt;attr multiple="true" name="NUMBER"&gt;
          &lt;string&gt;1&lt;/string&gt;
          &lt;string&gt;2&lt;/string&gt;
          &lt;string&gt;3&lt;/string&gt;
          &lt;string&gt;4&lt;/string&gt;
      &lt;/attr&gt;
      ...
  &lt;/attrs&gt;
  </code></pre>
  
  <p>I'm trying to have this result using XMLTABLE :</p>
  
  <pre><code>+------+--------+--------+
  | REF  | LETTER | NUMBER |
  +------+--------+--------+
  | REF1 | A      |      1 |
  | REF1 | B      |      2 |
  | REF1 | C      |      3 |
  | ...  | ...    |    ... |
  +------+--------+--------+
  </code></pre>
  
  <p>I'm very bad with Xpath, i'm stuck here but this concat all values :</p>
  
  <pre><code>XMLTABLE('/attrs'
      PASSING XMLTYPE(XML)
      COLUMNS LETTER VARCHAR2(50) PATH 'attr[@name="LETTER"]',
              NUMBER VARCHAR2(50) PATH 'attr[@name="NUMBER"]'
  ) X
  </code></pre>
  
  <p>Thanks.</p>