Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> SQL*Plus Spooling Question

SQL*Plus Spooling Question

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: 17 Jul 2001 11:54:11 -0700
Message-ID: <f98999c8.0107171054.7628ec35@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US