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;