Re: append to a spool file

Once you issue a spool, it writes over the previous version, you cannot append to it.
However, you can get the contents of the file to your SQL*Plus session using the get command.

SQL>  get myfile
SQL> 1 this is a test line from myfile
SQL>  spool myfile
SQL>  .
SQL>  .

If you are using unix, you can strip out any spool statements in your output using sed afterwards.

Not the most elegant solution, but a solution nonetheless!

M

"Dina Ghatit" <dghatit_at_nortelnetworks.com> wrote in message news:<9haamv$ngl$1_at_bcarh8ab.ca.nortel.com>...
> When I use the spool command I want to be able to append to the same file.
> Any ideas?
>
> spool myfile
>
> I want to append to myfile each time I run my sqlplus script.
> Thanks.
Received on Sun Jul 22 2001 - 08:53:09 CEST