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: Johan Thorselius <johan.thorselius_at_outright.se>
Date: Thu, 07 Jan 1999 20:44:41 +0100
Message-ID: <36950EA9.DD1C311@outright.se>


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

Original text of this message

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