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: James Hanway <hanwayj_at_dfo-mpo.gc.ca>
Date: Mon, 01 Nov 1999 16:41:03 GMT
Message-ID: <381DC2BF.AF9FC8B1@dfo-mpo.gc.ca>


If this is in UNIX, perhaps you can SPOOL to a FIFO file, and have a background unix process to append from the FIFO to the end of an existing file?

screwbai_at_my-deja.com wrote:

> 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 - 10:41:03 CST

Original text of this message

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