Re: What is spool command? - Site Owners Forums

samhanrey1 · 05-12-2012, 03:53 AM

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.

isoconsultantgm · 05-28-2012, 10:28 PM

nice post thanks for sharing this command.

jeny · 05-29-2012, 12:22 AM

Thanks for this explanation.

blueapple · 05-29-2012, 01:52 AM

thanks for important information.

Giraz john · 05-29-2012, 04:31 AM

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.

Robbin07 · 05-30-2012, 01:22 AM

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

spaculus · 05-30-2012, 06:10 AM

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

05-12-2012, 03:53 AM	#1
samhanrey1 Registered User Join Date: May 2012 Posts: 10	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. __________________ Online Home Business talk \| Turnkey Website Design talk

05-28-2012, 10:28 PM	#2
isoconsultantgm Registered User Join Date: May 2012 Posts: 117	nice post thanks for sharing this command. __________________ ISO 14001 \|\| Six Sigma Training

05-29-2012, 12:22 AM	#3
jeny Registered User Join Date: Dec 2011 Posts: 324	Thanks for this explanation. __________________ Relationship Tips and Advice for Women\|Arab Women Now \|Positive Thinking

05-29-2012, 04:31 AM	#5
Giraz john Registered User Join Date: Sep 2011 Posts: 99	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. __________________ FREE SEO Tool \| SEO Services \| FREE Web Directory \| WEBMASTER FORUM

05-30-2012, 06:10 AM	#7
spaculus Registered User Join Date: May 2012 Location: India Posts: 64	Nice information but i thing it is in wrong category.. __________________ Website Development Company, Web Design Company, Best SEO Company

05-29-2012, 01:52 AM	#4
blueapple Registered User Join Date: Feb 2012 Posts: 92	thanks for important information.

05-30-2012, 01:22 AM	#6
Robbin07 Registered User Join Date: May 2012 Posts: 50	Really interesting information and this is useful for us, now we use this.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: