parameter in sqlplus

From: Neilc <neilc-olops_at_btinternet.com>
Date: Thu, 2 Sep 1999 13:13:22 +0100
Message-ID: <7qlpo9$1fe$1_at_pheidippides.axion.bt.co.uk>

[Quoted] [Quoted] How can I prevent the output appearing in a spool file when passing parameters to a sqlplus script.

So I run sqlplus -s user/passwd _at_scriptname 200

The script is as follows :-

set echo off
set term off
set pages 0
set feedback off

--
spool spoolfile
select * from tablename where columnname < sysdate - &1
/
spool off
exit

In the spool file i get the following :-

old : sysdate - &1
new : sysdate - 200

thanks

Neil

Received on Thu Sep 02 1999 - 14:13:22 CEST