How to spool sql statement to log file

[bgill]

change your script to this:




sqlplus -s set serveroutput on
set echo on
set time on
set timing on
spool /home/xxx/update_xxx.log

select *
from emp ;

spool off;

Note: this will overwrite the "/home/xxx/update_xxx.log" each time you run the sql script.