title: How to insert new line when generating xml from SQLPLUS
body: <p>The XML generated by using </p>
  
  <pre><code>XMLAgg(XMLElement('student', ...)...)
  </code></pre>
  
  <p>spits out everything onto one line. Given that I have a very large table, it reaches line length limit when spooling.</p>
  
  <p>I'd like to have each &lt;student>...&lt;/student> node on a separate line. <a href="https://www.ibm.com/developerworks/mydeveloperworks/blogs/xmldatabase/entry/how_to_generate_xml_from_relational_data_with_line_breaks?lang=en" rel="nofollow">This</a> page suggests using XMLText(x'0A') to insert new lines, but SQLPlus doesn't seem to recognize it.</p>
  
  <p>I've already tried :</p>
  
  <pre><code>set long 2000000000
  set linesize 32767
  set wrap on
  set trimspool on
  </code></pre>