title: Select the child node in Oracle xmltype
body: <p>Requirement is to display the Contact details stored in xmlformat.
  My dataset as below:</p>
  <pre class="lang-none prettyprint-override"><code>Id   XMldata
  123  &quot;&lt;row id=&quot;123&quot;&gt;&lt;c1&gt;Home&lt;/c1&gt;&lt;c1 m=&quot;2&quot;&gt;Office&lt;/c1&gt;&lt;c1 M=&quot;3&quot;&gt;Personal&lt;/c1&gt;&lt;c2&gt;+91&lt;/c2&gt;&lt;c2 m=&quot;2&quot;&gt;+65&lt;/c2&gt;&lt;c2 m=&quot;3&quot;&gt;+1&lt;/c2&gt;&lt;c3&gt;9900990090&lt;/c3&gt;&lt;c3 m=&quot;2&quot;&gt;55667788&lt;/c3&gt;&lt;c3 m=&quot;3&quot;&gt;123789073&lt;/c3&gt;&lt;c4&gt;Test element&lt;/c4&gt;&lt;/row&gt;&quot;
  </code></pre>
  <p>I need to build a select query to select child node matching Office contact details and to view the output in the below format:</p>
  <pre class="lang-none prettyprint-override"><code>Id  C1     C2  C3 
  123 Office +65 55667788
  </code></pre>