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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Append output to file in SQLPlus?

Re: Append output to file in SQLPlus?

From: Andreas Wenzel <a.wenzel_at_aon.at>
Date: Fri, 06 Oct 2000 21:04:38 +0100
Message-ID: <6o7lr8.oo4.ln@pc27.delphi.at>

In article <8rds45$jtb$1_at_brokaw.wa.com>, "Peter Amundson" <peter.amundson_at_cotlnospam.com> wrote:
> Is there an option to append your output to an existing file, rather
> than overwriting or creating a new file? SPOOL doesn't seem to have an
> 'append' parameter. Any help would be appreciated -- thanks in advance!
>
> -Peter

Redirect stdout to this file!
But first place the following into your script: set feed off verify off echo off pages 0

and start your sqlplus-session with "sqlplus -s @..."

-- 
GnuPG ID   : 74772303
Fingerprint: 7183 A83C C582 040A 40CA  F985 2C4C 19B8 7477 2303
Received on Fri Oct 06 2000 - 15:04:38 CDT

Original text of this message

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