Re: Append output to file in SQLPlus?

From: Peter Amundson <pjamundson_at_cotlnospam.com>
Date: Fri, 6 Oct 2000 15:26:57 -0700
Message-ID: <8rljnr$m02$1@brokaw.wa.com>

Thanks for the reply! This is either not quite what I had in mind, or I need a little more info on what this means. I use SQLPlus for many administrative tasks, so I've got it open all day long. I want to append output to an existing text file for one particular script only. Also, it may be important to note that I'm running SQLPlus on my NT desktop. Thoughts?

"Andreas Wenzel" <a.wenzel_at_aon.at> wrote in message news:6o7lr8.oo4.ln_at_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 - 17:26:57 CDT