Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suppressing old/new message in SQL*Plus
Issue the following SQL*Plus command:
SET VERIFY OFF With verification off, you won't see the before and after images of each line.
regards,
Jonathan
On Thu, 07 Jan 1999 19:22:40 GMT,
pantah_at_commonsense.a2000.nl (JanJan) wrote:
>When I use parameters (&1, &2...) in an sql script, upon execution,
>all lines that contain these values are echoed as they were (old:) and
>how they will be executed the substituted value (new:).
>Is there a way to avoid having these lines echoed? The -s parameter
>only suppresses the "connected" blah-blah, not the old & new messages.
>
>Thanks
Received on Thu Jan 07 1999 - 19:13:14 CST
![]() |
![]() |