title: oracle sqlplus does not give long result
body: <p>I have a simple sql script file which only includes a SELECT statement. But the output of SELECT statement is huge (more than a few hundred thousands lines).</p>
  
  <p>I cannot get output saved in a local file. I just changed my select statement to DESC and it worked fine, so the problem seems the size of output (select statement is something like SELECT * from TABLEX)</p>
  
  <p>I will appreciate any comments on how to execute the select statement..</p>
  
  <p>Thanks in advance</p>
  
  <hr>
  
  <p>I updated my sql script file as below</p>
  
  <pre><code>SET SQLBLANKLINES ON
  set echo off  
  set feedback off  
  set linesize 1000  
  set pagesize 0  
  set sqlprompt ''  
  set trimspool on  
  set headsep off  
  
  spool output.csv  
  select * from JM_WCEL_BTH_CURRENT  
  SPOOL OFF  
  EXIT
  </code></pre>
  
  <p>The output is below</p>
  
  <pre><code>D:\&gt;sqlplus user/user@mydb @2.sql
  
  SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 17 10:10:15 2013
  
  Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
  
  
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
  With the Partitioning, Data Mining and Real Application Testing options
  
    4
    5
  Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64
  bit Production
  With the Partitioning, Data Mining and Real Application Testing options
  
  D:\&gt;
  </code></pre>
  
  <p>There is nothing in the output file but numbers 4 and 5. I ended the process after a few minutes by pressing Ctrl + C. I also tried removing spooling process, there is no output to console as well.</p>
  
  <p>I tried to run the sql query from ay other tool, it gives results in less than a second!</p>
  
  <p>Any suggestions?</p>
  
  <p>Thanks</p>