Re: Problem with & in SQL*PLUS

In article <itkennet.6.0026A1B7_at_polyu.edu.hk>, itkennet_at_polyu.edu.hkß says...
>
>
>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?
>
>Thanks in advance.
> '"'

There are actually two ways to do it. You can use the SET DEFINE command to change the scan character from '&' to whatever you want. SET DEFINE also lets you turn scanning off completely. or
You can use the SET SCAN OFF command to turn scanning off. Both commands can be used to turn scanning back on.

• Ennio