Re: suppressing old:/new:

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>Is there a way so suppress the "old:" and "new:" lines when SQLPLUS
>performs a variable substitution? For example:
>
>SQL> define block_size = 2048
>SQL> select &block_size from dual;
>old 1: select &block_size from dual
>new 1: select 2048 from dual
>
>I don't want it in my output since I'm trying to create a script with
>the output.
>--
>Chuck Hamilton
>chuckh_at_ix.netcom.com
>
>Incoming fire has the right of way!
>

In SQLPLUS use SET VERIFY OFF.

-- 
 
Mike Morgan
Technology Integration Services - Unix DBA

email: mike.morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"Murphy's Law of computing:  Anything that can go wrSegmentation 
fault(coredump)"
*******************************************************