spool
sends the output that is normally written to the console also to a file or printer, or (spool off
) turns this additional output off. set termout off
prevents printing output to the console, which is especially useful while spooling to a file. spool.sql
and spool_off.sql
are two SQL scripts for $SQLPATH
that modify SQL*Plus settings in a way that spool
creates clean output.