Re: How to suppress old new in sqlplus when passing parameters?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/03/21
Message-ID: <3515289a.6777014_at_192.86.155.100>#1/1

A copy of this was sent to "Robert Augustyn" <augustyn_at_unn.unisys.com> (if that email address didn't require changing) On Fri, 20 Mar 1998 15:05:25 -0500, you wrote:

>Hi,
>I am spooling the output of the sql to the file and I am passing parameters.
>When I do that sqlplus displays:
>
>old 5: '&&1'||'_'||translate(report_type,' &','--')||'_'||
>new 5: 'Weekly'||'_'||translate(report_type,' &','--')||'_'||
>
>and the output of the sql
>how can I suppress it?
>Thanks in advance
>robert
>

SQL> set verify off  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA  

http://govt.us.oracle.com/ -- downloadable utilities  

---

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

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Mar 21 1998 - 00:00:00 CET