The SPOOL command is used to write output to a text file. You must use this if you are going to print a report. The only way to print a report is to spool it to a file, then print that file. See Chapter 3 for an example of SPOOL being used to generate a report file. SPOOL may also be used to generate a new file of SQL commands to be executed. Chapter 7 shows you how to take advantage of that powerful technique.
SP[OOL] file_name
|OFF|OUT
where:
May be abbreviated to SP.
Is the name of the file to which you want to write the report. 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. You must have turned spooling on before you can turn it off.
Turns spooling off, and prints the file on the default printer. This option is not available in the Windows versions of SQL*Plus.