Spool command in oracle

Spool Of/On

Sends standard output, informational messages, error messages, and/or warning messages generated by the execution to the file.

If file-name does not exist, it is created. If file-name already exist, it is overwritten..

if a directory does not exist, file-name is created in the current directory.

Example

spool on to 'output.txt';

spool on to 'c:\students\output.txt';

Share this

Hemalata