SPOOl Command in Oracle

In this article You will learn how to use SPOOL Command in SQL Server.

SPOOL Command:-

A command called SPOOL that can send the output from any SQL statement to a file. Indeed, anything that is displayed in SQL*Plus can be echoed to this spool file. The SPOOL command is invoked with the name of a file that will contain the output. Once this has been executed, the output from all subsequent SQL statements will be copied to the file. To end capturing the output, issue the SPOOL OFF command.

Spooling can be used in two type one through the write some command in PL/SQL prompt and other option can be used command prompt menu option. it will be create when:

First option to use SPOOL command through the command prompt menu:

oracle SQL*plus->File->spool->spool file 

-- write the statement in oracle SQL*Plus  after the statement end of the spool through the spool off.

Such as:

spool1.gif

now Click the spool file than spooling will be start and select the path.

after selecting the path execute some statement on the command prompt it will be save in a file to the proper place where you have selected the path.

at the end close the spool command with the option spool off. such as

oracle SQL*plus->File->spool->spool off

now open the file file will be created with statement output.

Second option to use the spool command through the write command in command prompt:

spl2.gif
file File1 is created in the proper define path with the output.The SPOOL OFF command turns the output off. Everything between SPOOL c:\file1.out and SPOOL OFF will be in the file file.out

SPL3.gif
Read more articles related Oracle Click Here