Data Base Tips/ SQL Commands...

Tuesday, August 02, 2005

Creating a Spool File

Male sure you save each session. This is especially useful at the beginning of your learning experience. Spool files help you analyze the mistakes you make and allow you to continue at a later time as opposed to start all over again. To Create a spool file, you can type:


SQL> spool c:\My Documents\sessionName.lst


The .lst(list) qualifier is nto required, but is highly recommended.

When you complete your session, it is a good practice to close your spool file :


SQL> Spool off;


Post a Comment

<< Home