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

From: <pberetta_at_my-deja.com>
Date: Mon, 13 Dec 1999 13:12:21 GMT
Message-ID: <832rbk$3hl$1_at_nnrp1.deja.com>

Salman,

Try this:

SET VERIFY OFF
select *
from TABLE

where    column1  = &1
 and     column2  = 'N'
 and     column3  ='CONNECT'

order by ACTDATE;
SET VERIFY ON This should supress the OLD/NEW displays. Hope this helps,
Paul

In article <3854D89F.D3F83FEC_at_cyber.net.pk>, Syed Salman Shakir <ssalman_at_cyber.net.pk> wrote:
>
> --------------CDE375F55C8862A9671B4383
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> 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
>
> --------------CDE375F55C8862A9671B4383
> 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
> 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--
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 14:12:21 CET

This message: [ Message body ]
Next message: Phil Britton: "Re: How to use sql from JAVA"
Previous message: ⡷牯湧⁳瑲楮朩⃉物挠䑡湴楥: "Re: SQLPLUS: How can I stop echoing &1 value in SQLPlus tool"
In reply to Syed Salman Shakir: "SQLPLUS: How can I stop echoing &1 value in SQLPlus tool"
Next in thread: Karl R.: "Re: Missing Bitmaps with Developer Foms Server 6.x and OAS 4.0.7"

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

Original text of this message