Name
SPOOL
Synopsis
SP[OOL] filename | OFF | OUT
The SPOOL command causes output to be written to a text file. For example:
SPOOL c:\data\emp_pay_report SPOOL OFF
Parameters
- filename
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.
- OFF
Turns spooling off.
- OUT
Turns spooling off and prints the file on the default printer. This option is not available in the Windows versions of SQL*Plus.
Get Oracle SQL*Plus Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
