Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> SQL*Plus Spooling Question
I have a bunch of long running scripts that I need to run, and I always use a standard header in each. Is there a symbolic parameter that I can use such that the filename will be used in the .lis file? E.g. I want the following (assume ALTER.SQL)
SET ECHO ON
SET SCAN OFF
SET AUTOTRACE OFF
SET PAUSE OFF
SPOOL C:\LIS\ALTER.LIS
WHENEVER SQLERROR EXIT SQL.SQLCODE;
SELECT * FROM GLOBAL_NAME;
to be
SET ECHO ON
SET SCAN OFF
SET AUTOTRACE OFF
SET PAUSE OFF
SPOOL C:\LIS\%FILE.LIS < -- Symbolic for filename
WHENEVER SQLERROR EXIT SQL.SQLCODE;
SELECT * FROM GLOBAL_NAME;
Received on Tue Jul 17 2001 - 13:54:11 CDT