Re: parameter in sqlplus

A copy of this was sent to "Neilc" <neilc-olops_at_btinternet.com> (if that email address didn't require changing) On Thu, 2 Sep 1999 13:13:22 +0100, you 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
>
>thanks
>
>Neil
>

set verify off

as well...

-- 
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation