Appending a spool file [message #372239] |
Mon, 22 January 2001 03:23 |
jimmy
Messages: 21 Registered: November 2000
|
Junior Member |
|
|
Hi
Is it possible to append a spool file?
I have two .sql files that spools to the same file and I want the result from both .sql files to appear in the same spool file.
Thanks!
Jimmy
|
|
|
Re: Appending a spool file - no [message #372250 is a reply to message #372239] |
Mon, 22 January 2001 12:05 |
Andrew again...
Messages: 270 Registered: July 2000
|
Senior Member |
|
|
As far as I know it's not possible. You'd have to do it as an operating sustem command called from your SQL script running in SQL*Plus like this:
1.) unix:
! cat file1 file2 > file3
or
host cat file1 file2 > file3
2.) NT:
host copy file1 + file2 file3
|
|
|