Re: SQL*Plus extraneous output

Terry Bell wrote:
>
> Oops, dropped my sig file from the last one.
>
> ----
> How do I supress these old and new messages that appear before my select
> output?
>
> old 1: select %FIELDNAME from &SCHEMA&TABLENAME where %KEYFIELD =
> %KEYVALUE for update
> new 1: select MY_FIELD from MY_SCHEMA.MY_TABLE where MY_KEY = 1997020
> for update
>
> I am using the following settings:
>
> set pagesize 800
> set linesize 2100
> set feedback off
> set headsep off
> set showmode off
> set underline off
> set verify off
>
> Any ideas?
>
> ----
> ============================================================
> Terry Bell
> mailto:tbell_at_kamloops.env.gov.bc.ca
>
> British Columbia Ministry of Environment, Lands and Parks
> http://www.env.gov.bc.ca
>
> Assistant DBA Co-op Student from
> Computer Systems Operations and Management(CSOM) Program at
> The University College of the Cariboo
> http://www.cariboo.bc.ca
> ============================================================

'set verify off' should do the trick:

SQL> select * from dual where &1 = 1;
Enter value for 1: 1
old 1: select * from dual where &1 = 1 new 1: select * from dual where 1 = 1

D
-
X

SQL> set verify off
SQL> /
Enter value for 1: 2

no rows selected

Ed Bradt Received on Fri Aug 08 1997 - 00:00:00 CDT