Home » RDBMS Server » Server Administration » Appending a spool file
Appending a spool file [message #372239] Mon, 22 January 2001 03:23 Go to next message
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 Go to previous message
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
Previous Topic: Deleting duplicate rows
Next Topic: Tough SQL*Plus question
Goto Forum:
  


Current Time: Mon Dec 23 01:00:56 CST 2024