Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Suppressing old/new message in SQL*Plus

Re: Suppressing old/new message in SQL*Plus

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 8 Jan 1999 01:13:14 GMT
Message-ID: <369b5776.32515249@netnews.worldnet.att.net>


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



Jonathan Gennick
gennick_at_worldnet.att.net
http://home.att.net/~gennick
Brighten the corner where you are.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US