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. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

05-28-2012, 10:28 PM	#2
isoconsultantgm Registered User Join Date: May 2012 Posts: 117	nice post thanks for sharing this command. __________________ *To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.* \|\| *To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.*

05-29-2012, 12:22 AM	#3
jeny Registered User Join Date: Dec 2011 Posts: 324	Thanks for this explanation. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

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. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. \| To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

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.. __________________ To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts. , To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

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)