August 2002
Intermediate to advanced
528 pages
10h 12m
English
The results of your query are permanently captured by using the SPOOL command. This command causes SQL*Plus to begin writing all screen output to an external file. SQL*Plus will continue to output to the file until the SPOOL OFF command is issued. The external file that the SPOOL command created can then be printed using any Windows software, such as Notepad, Word, or WordPerfect. If you would like to stop the spooling process and print the output, use the SPOOL OUT command.
The command can be entered as a line command, selected from the File/Spool menu option, or it can be placed inside the query file. The following is the syntax of the command:
Spool filename Spool c:/test.txt
Chapter 11 has a more complete ...