SQLPLUS: How can I stop echoing &1 value in SQLPlus tool

From: Syed Salman Shakir <ssalman_at_cyber.net.pk>
Date: Mon, 13 Dec 1999 16:29:35 +0500
Message-ID: <3854D89F.D3F83FEC_at_cyber.net.pk>

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Hi All,
I've written an sql script as follows

select *
from TABLE
[Quoted] where column1 = &1

[Quoted] 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

--------------CDE375F55C8862A9671B4383
[Quoted] Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
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 [Quoted]
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
  </html>

--------------CDE375F55C8862A9671B4383-- Received on Mon Dec 13 1999 - 12:29:35 CET

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message