how to redirect an output to a spool file in sqlplus

Many times when you run a sql file, we need to get the output for further analysis , but if the screen buffer is too small , there are chances to miss the output . So it is always a good idea to spool your output to a file which will be stored in your local harddisk. Lets see how to enable spooling in sqlplus.

Open your sqlplus , Go to File –>  Spool –> Spool file

Locate where to create the spool file and give a file name

After running the script , Go to File –> Spool –> Spool off

Tags: howto