Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Suppressing old/new message in SQL*Plus
Try these three lines (I don't have Oracle on hand right now). One line of
them will probably do what you want:
SET VER OFF
SET ECHO OFF
SET FEEDBACK OFF
Johan Thorselius
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
> --
> Jan
> pantah_at_commonsense.a2000.nl
> (replace "commonsense" with "speed" to reply)
Received on Thu Jan 07 1999 - 13:44:41 CST
![]() |
![]() |