Writing sqlplus output to a file

Using sqlplus.exe I'm looking for a way to write sqlplus output to a file.

Is there anyway I can do that, currently the output is written only to the console.

You may use the SPOOL command to write the information to a file.

Before executing any command type the following:

SPOOL <output file path>

All commands output following will be written to the output file.

To stop command output writing type

SPOOL OFF

Also note that the SPOOL output is driven by a few SQLPlus settings:

• SET LINESIZE nn - maximum line width; if the output is longer it will wrap to display the contents of each result row.

• SET TRIMSPOOL OFF|ON - if set OFF (the default), every output line will be padded to LINESIZE. If set ON, every output line will be trimmed.

• SET PAGESIZE nn - number of lines to output for each repetition of the header. If set to zero, no header is output; just the detail.

Those are the biggies, but there are some others to consider if you just want the output without all the SQLPlus chatter.