Re: Is there a way to append spool files?

SQL> help spool

  SPOOL

  Stores query results in a file, or optionally sends the file to a printer.   In iSQL*Plus, use the Preferences screen to direct output to a file.

  SPO[OL] [file_name[.ext] [CRE[ATE] | REP[LACE] | APP[END]] | OFF | OUT]

  Not available in iSQL*Plus

HTH
Michael

Quoting Pete Finnigan <pete_at_petefinnigan.com>:

> Hi All,
>
> I have been asked by someone whether its possible to append to a spool
> file in sql*plus. i.e. do something like:
>
> spool file.a
> do some sql
> do some more sql
> spool off
>
> spool file.b
> do some sql
> do some sql
> spool off
>
> spool file.a -- but do not lose the original content BUT add to it
> do some sql
> do some sql
> spool off
>
> The only thing I can think of is to use os commands to save the file
> before the second spool and use cat afterwards to build the file but it
> would be nice to be able to do it in sqlplus only?
>
> cheers
>
> Pete
>
> --
>
> Pete Finnigan
> Director
> PeteFinnigan.com Limited
>
> Specialists in database security.
>
> If you need help to audit or secure an Oracle database, please ask for
> details of our courses and consulting services
>
> Phone: +44 (0)1904 791188
> Fax : +44 (0)1904 791188
> Mob : +44 (0)7742 114223
> email: pete_at_petefinnigan.com
> site : http://www.petefinnigan.com
>
> Registered Office: 9 Beech Grove, Acomb, York, YO26 5LD, United Kingdom
> Company No : 4664901
> VAT No. : 940 6681 14
>
> Please note that this email communication is intended only for the
> addressee and may contain confidential or privileged information. The
> contents of this email may be circulated internally within your
> organisation only and may not be communicated to third parties without
> the prior written permission of PeteFinnigan.com Limited. This email is
> not intended nor should it be taken to create any legal relations,
> contractual or otherwise.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l