SQL*Plus User's Guide and Reference Release 9.0.1 Part Number A88827-02 |
|
Command Reference, 43 of 52
SPO[OL] [file_name[.ext]|OFF|OUT]
Stores query results in a file, or optionally sends the file to a printer.
Refer to the following list for a description of each term or clause:
file_name[.ext]
OFF
OUT
Enter SPOOL with no clauses to list the current spooling status.
To spool output generated by commands in a command file without displaying the output on the screen, use SET TERMOUT OFF. SET TERMOUT OFF does not affect output from commands run interactively.
To record your displayed output in a file named DIARY using the default file extension, enter
SPOOL DIARY
To stop spooling and print the file on your default printer, enter
SPOOL OUT
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|