Re: What is spool command?
 

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.

nice post thanks for sharing this command.

Thanks for this explanation.

thanks for important information.

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. It enables you to review the output later, without having to worry about it scrolling off the top of the screen.

Really interesting information and this is useful for us, now we use this.

Nice information but i thing it is in wrong category..