title: SQLPLUS : Stop Terminal output while spool to a file
body: <p>How to stop terminal output in Unix while SQLPLUS and spooling the output in a file? </p>
  
  <p>I tried <code>serveroutput</code>, <code>echo</code>, <code>termout</code>, <code>feedback</code> in OFF mode but no luck.</p>
  
  <p>Also it is showing logon details as well .</p>
  
  <pre><code>sqlplus -s  $LOGON  &lt;&lt; EOF
      WHENEVER OSERROR EXIT 9;
      WHENEVER SQLERROR EXIT 9;
      set serveroutput off;
      set echo off;
      set termout off;
      set feedback off;
      set heading off;
      set linesize 10000;
      set colsep "|";
      set trims on;
      set trimspool on;
      set pagesize 0;
      spool Summary.txt
      ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY';
      Select * from Customer;
      spool off;
      EXIT;
      EOF
  </code></pre>
  
  <p>PS : I am calling this statement in a Unix Script </p>