title: Log file avoid dumping sql query data in it.. c shell
body: <p>I have sql script "example.sql":</p>
  
  <pre><code>SPOOL &amp;1
  Select '&lt;.TR&gt;'||'&lt;.TD align="left"&gt;'||column_name||'&lt;./TD&gt;'||'&lt;.TR&gt;' from table1;
  spool off
  </code></pre>
  
  <p>which dumps it contents to cshell script "getdata.csh" this is how i get data from sql script to csh script</p>
  
  <pre><code>sqlplus $ORA_UID/$ORA_PSWD @${SQL}example.sql ${DATA}${ext}
  </code></pre>
  
  <p>My problem is when I run my job to do this it dumbs all data extracted from sql query in log file too.. How can I avoid dumbing data into log files. What do I have to do in this code to do so? thank you</p>