Re: How to suppress old new in sqlplus when passing parameters?
From: Marc Nicholls <marc.nicholls_at_mcmail.com>
Date: 1998/03/20
Message-ID: <3512ecd6.0_at_news1-hme0.mcmail.com>#1/1
Date: 1998/03/20
Message-ID: <3512ecd6.0_at_news1-hme0.mcmail.com>#1/1
Use
SQL> set verify off
before you run the SQL
Regards
Marc
Robert Augustyn wrote in message <6eui8b$7i4$1_at_mail.pl.unisys.com>...
>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
>
>
Received on Fri Mar 20 1998 - 00:00:00 CET