SET termout off
SET feedback off
SET timing off
SET echo off
SET heading off
SET pageSIZE 0
SET lineSIZE 10000
SET long 5000
SET arraySIZE 5000
SET trimout on
SET trimspool on
SPOOL '/report/mac/lwp/cs/a.txt'
select ......
SET feedback off
SET timing off
SET echo off
SET heading off
SET pageSIZE 0
SET lineSIZE 10000
SET long 5000
SET arraySIZE 5000
SET trimout on
SET trimspool on
SPOOL '/report/mac/lwp/cs/a.txt'
select ......
SPOOL off
若不需显示输出结果过可把sql文件先ftp到服务器上然后@sql文件所在目录和名称如@/weblogic/lwp2/a.sql