title: Max column width in Oracle spool to file
body: <p>I have a script like this:</p>
  
  <pre><code>SET ECHO OFF
  SET FEEDBACK OFF
  SET VERIFY OFF
  SET HEADING OFF
  SET TERMOUT OFF
  SET TRIMOUT ON
  SET TRIMSPOOL ON
  SET WRAP OFF
  SET LINESIZE 32000
  SET LONG 32000
  SET LONGCHUNKSIZE 32000
  SET SERVEROUT ON
  
  SPOOL C:\Export.txt
  
  SELECT XMLELEMENT("element1",xmlelement("element2",xmlattributes(.....)))
    FROM --TABLENAME--
   WHERE --CONDITIONS--
  </code></pre>
  
  <p>The output should be a file containing a list of rows with the complex xml inside, but when the length of the XML generated is longer than 2000, SQLPlus trims to 2000 and go to the next line.</p>
  
  <p>There is a way to force SQLPlus to write all the data in the same line?</p>