Re: supress old/new lines in SQL*Plus scripts

From: TurkBear <jgreco1_at_mn.rr.com>
Date: Fri, 23 Aug 2002 15:14:11 -0500
Message-ID: <7p5dmugfnh4eub36cojc06ltdust6uv9h8_at_4ax.com>


[Quoted] If you are using scripts, I assume you have a manual handy.. if not, try

Set verify off

at the start of your scripts..

"Steve Mitchell" <stevem_at_hdcsi.com> wrote:

>
>I have a suite of scripts I use to perform common queries. I use &1, &2,
>etc., to do parameter replacement within these scripts. This works great,
>but SQL*Plus has this annoying habit of printing out the old line and the
>new line before and after the replacement respectively. I would like to
>suppress this somehow:
>
>company_42_at_dilbert> @chargetag 1439
>old 6: voucherhdridx = &1
>new 6: voucherhdridx = 1439
>
>VOUCHERHDRIDX VENDNAMEIDX VENDINVCNO VENDINVCDATE
>------------- ----------- ------------ -----------------
> 1439 13 08/20/2002 000000
>
>
>Thanks for any pointers.
>
>--steve
>
>

[Quoted] -----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! [Quoted] -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Aug 23 2002 - 22:14:11 CEST

Original text of this message