set heading off set feedback off spool temp.txt --你自己把这个路径改了 select * from aa;--自己写sql spool off exit EOF
set trimspool on set linesize 120 set pagesize 2000 set newpage 1 set heading off set term off set echo off //撤消回显 spool d:\temp.txt select * from table; spool off
set feedback off
spool temp.txt --你自己把这个路径改了
select * from aa;--自己写sql
spool off
exit
EOF
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
set echo off //撤消回显
spool d:\temp.txt
select * from table;
spool off