Is there a way to append spool files?
Date: Fri, 28 Nov 2008 08:25:30 +0000
Message-ID: <492FAAFA.8040509@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
Received on Fri Nov 28 2008 - 02:25:30 CST