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.

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.

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