Re: Problem with & in SQL*PLUS

itkennet_at_polyu.edu.hk (Kenneth Yuen) wrote:

>In my 'Insert' statement, I have the data value like 'R & D'. When run with
>SQL*PLUS, it paused me to enter the new value. Can anyone tell me how
>to temporarily disable the interpretation of & in sqlplus and enable it
>back after the executive of the script?

Use "set scan off" before your insert.

Paul Baumgartel, Principal Consultant              paulb_at_pcnet.com 
Adept Computer Associates, Inc.                                    
********************************************************************