title: How to order the fields getting aggregated by XMLAGG function?
body: <p>I have the below table:</p>
  
  <pre><code>Part_number   seq_nbr    Super_narrative
  1                1        When replacing
  1                2        part  with following parts
  1                3        note:follwing are now available
  1                4        with the organization 
  </code></pre>
  
  <p>I am using the XMLAGG to aggregate the super_narrative in 1 line corresponding to part_number.</p>
  
  <pre><code>SELECT serv_part_nbr, rtrim (xmlagg (xmlelement (e, Super_narrative || ', ')).extract ('//text()'), ',') PHRASE_TEXT 
  FROM BL_MACS_SUPERSEDENCE_NOTE
  GROUP BY part_number
  </code></pre>
  
  <p>But I want to aggregate the <code>super_narrative</code> according to <code>seq_nbr</code>.</p>
  
  <p>How to do that??</p>