Monday 2 September 2013

How to spool sql statement to log file

spool /home/xxx/update_xxx.log

sqlplus -s <!
set serveroutput on
set echo on
set time on
set timing on

select *
from MTL_CATEGORIES_B;


Spool off;

No comments:

Post a Comment