Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can SPOOL append?

Re: Can SPOOL append?

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 1 Nov 1999 23:05:34 GMT
Message-ID: <01bf24bd$a6ec8300$024d95c1@default>


SPOOL overwrites. Maybe you chould write a Unix script and append your output to the existing file?

cheers

Glenn Baron

screwbai_at_my-deja.com wrote in article <7vk46v$v8l$1_at_nnrp1.deja.com>...
>
>
> I use the the spool command. Let say that I use an sql that has SPOOL
> and SPOOL OFF on it and I want to accumulate the output for every time I
> run it into one single file. The SPOOL command seems to delete the
> existing content of the file.
>
> Is there anywhat I can tell the SPOOL command to append to the file.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Mon Nov 01 1999 - 17:05:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US