Name

SPOOL

Synopsis

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

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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset