Re: SQLPLUS: How can I stop echoing &1 value in SQLPlus tool
From: Oracle Enterprise Internet Tools Product Management <no_replies_at_uk.oracle.com>
Date: Mon, 13 Dec 1999 12:18:43 -0000
Message-ID: <832ocl$c50$1_at_inet16.us.oracle.com>
Date: Mon, 13 Dec 1999 12:18:43 -0000
Message-ID: <832ocl$c50$1_at_inet16.us.oracle.com>
set verify off
-- Regards Jason ____________________________________________________________________________ __ Jason Pepper - Enterprise Internet Tools Product Management ____________________________________________________________________________ __ Opinions are mine and do not necessarily reflect those of Oracle Corporation Syed Salman Shakir <ssalman_at_cyber.net.pk> wrote in message news:3854D89F.D3F83FEC_at_cyber.net.pk...Received on Mon Dec 13 1999 - 13:18:43 CET
> Hi All,
> I've written an sql script as follows
>
> select *
> from TABLE
> where column1 = &1
> and column2 = 'N'
> and column3 ='CONNECT'
> order by ACTDATE;
>
> I saved it in a file and executed it from the SQL prompt as follows
>
> SQL> _at_filename 1010000
>
> When this command executes, first it displays the old and new value of
> &1 as follows
>
> old 4: where custnum = &1
> new 4: where custnum = 1010001
>
> and then display the resulting values.
>
> My question is how could I prevent my self from this OLD and NEW value
> echo?
> I dont want this echo. I need only the resulting values.
>
> Thanks in advance.
>
> Best Regards,
> Salman
>
>