SPOOL
SP[OOL] filename | OFF | OUT
The SPOOL command causes output to be written to a text file. For example:
SPOOL c:dataemp_pay_report SPOOL OFF
Is the name of the file to which you want to write the output. The default extension depends on the operating system and will be either LST or LIS. Under Windows 95 and NT, it is LST. A path may be specified as part of the filename.
Turns spooling off.
Turns spooling off and prints the file on the default printer. This option is not available in the Windows versions of SQL*Plus.