SPOOL
SPOOL

Displays the current spooling status.

SPO[OL] [filename[.extension]] | [OFF | OUT]

Spools all subsequent SQL*Plus output to a file.

Keywords

filename[.extension]

The filename and optional extension for the file to which the output will be written. If an extension is not supplied, .LIS or .LST (depending on the platform) will be used as the extension.

OFF

Stops spooling.

OUT

Stops spooling, and sends the output file to the default printer. This option is not supported on all platforms. For example, it is not supported under Windows.

The SPOOL OFF command must be supplied when spooling is complete or the spooled file will not be saved.

Get Oracle SQL: the Essential 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.

Start your free trial