SQLPLUS: How can I stop echoing &1 value in SQLPlus tool
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,
<br>I've written an sql script as follows
<p><font face="Arial,Helvetica">select *</font>
<br><font face="Arial,Helvetica">from TABLE</font>
<br><font face="Arial,Helvetica">where column1 = &1</font>
<br><font face="Arial,Helvetica">and column2
= 'N'</font>
<br><font face="Arial,Helvetica">and column3
='CONNECT'</font>
<br><font face="Arial,Helvetica">order by ACTDATE;</font>
<p>I saved it in a file and executed it from the SQL prompt as follows
[Quoted]
<p><font face="Arial,Helvetica">SQL> _at_filename 1010000</font>
<p>When this command executes, first it displays the old and new value
of &1 as follows
<p><font face="Arial,Helvetica">old 4: where custnum = &1</font>
<br><font face="Arial,Helvetica">new 4: where custnum = 1010001</font>
<p>and then display the resulting values.
<p>My question is how could I prevent my self from this OLD and NEW value
echo?
<br>I dont want this echo. I need only the resulting values.
<p>Thanks in advance.
<p>Best Regards,
<br>Salman
<br> </html>
--------------CDE375F55C8862A9671B4383-- Received on Mon Dec 13 1999 - 12:29:35 CET