title: Increase number of rows in SQL Developer export
body: <p>I'm running a SQL script in SQL Developer and wanting to export all the records it returns to a CSV file, roughly a few hundred thousand results. </p>
  
  <p>Currently SQL Developer limits the number of rows it returns to 50.</p>
  
  <p>I've tried the following to fix this:</p>
  
  <ul>
  <li>Increasing SQL array fetch size (I receive a protocol[0] error)</li>
  <li>Increasing max rows to print to script (made no difference)</li>
  <li>Increasing the max lines in script output (made no difference) </li>
  </ul>
  
  <p>Code I'm using is as follows:</p>
  
  <pre><code>var UWY varchar2(20);
  var SHOWS_AT_DATE_DD_MON_YY varchar2(30)
  
  exec :UWY := '2012';
  exec :SHOWS_AT_DATE_DD_MON_YY := '31-dec-2014';
  
  SPOOL "c:\act-2012.csv";
  
      /* select statement */
  
  SPOOL OFF;
  </code></pre>