Re: parameter in sqlplus

From: Kenneth C Stahl <bluessax_at_unforgettable.com>
Date: Thu, 02 Sep 1999 08:28:58 -0400
Message-ID: <37CE6D89.190881AE_at_unforgettable.com>


Neilc wrote:

> 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
>

SET VERIFY OFF; Received on Thu Sep 02 1999 - 14:28:58 CEST

Original text of this message