title: ORACLE XML values extract as pivot
body: <p>i would like to know is there any way that i could get out put form xml file as pivot??</p>
  
  <p>my code </p>
  
  <pre><code>select t.extract('/S/@ID').getstringval() as s 
  FROM
  TABLE( 
  XMLSEQUENCE( 
  (select xmltype('&lt;?xml version="1.0"?&gt;
  &lt;SERIAL&gt;
  &lt;S ID="1E0100057107" /&gt;
  &lt;S ID="1E0100057108" /&gt;
  &lt;S ID="1E0100057109" /&gt;
  &lt;S ID="1E0100057110" /&gt;
  &lt;/SERIAL&gt;').extract( '//S' ) from dual)
  ))T;
  desired output 
  S
  -------------------------
  1E0100057107,1E0100057108,1E0100057109,1E0100057110
  </code></pre>
  
  <p>thank you..</p>