Thread: What is spool command?

Hi,
I have problem,please give the solution my problem.


Thank you for Advance..

Hi,
Spool is an Oracle based command. It is useful to save all your statements in any text file. You can create this file on your drive. This is the procedure to use it:
- First of all define the “txt” file location on the drive:
SQL> spool C:\temp.txt (temp file will be created in C drive)
- Run some statement:
SQL> select * from tablename1 (Output will be generated)
SQL> select * from tablename2 (Output will be generated)
- If you want to stop the spool then run another command:
SQL> spool off
This text file will contain all records after your file is created with errors/messages/outputs/results etc.

The SPOOL command is used to echo Server Manager's output to a text file. Spooling output to a file is a good thing to do whenever you run a script, or any other command that produces a lot of output.

Spool Command in ORACLE is used to transfer data from oracle tables into other files.

....................................
list management service |list management software |

SPOOL command in itself is a simple command. The issues are usually due to
the incorrect SQL*Plus environment setting (like linesize, heading, echo etc).

Go to the following site, it may help you:


SPOOL Command Usage and Related Issues in SQL*Plus