SET TERM[OUT] {ON|OFF}
SET TERMOUT is not supported in iSQL*PlusControls the display of output generated by commands executed from a script. OFF suppresses the display so that you can spool output from a script without seeing the output on the screen. ON displays the output. TERMOUT OFF does not affect output from commands you enter interactively.
SET TERMOUT is not supported in iSQL*PlusControls the display of output generated by commands executed from a script. OFF suppresses the display so that you can spool output from a script without seeing the output on the screen. ON displays the output. TERMOUT OFF does not affect output from commands you enter interactively.
set termout off
spool c:\test.txt
select * from test;
spool off然后在sqlplus中运行