Problem with & in SQL*PLUS

From: Kenneth Yuen <itkennet_at_polyu.edu.hk>
Date: 1996/01/25
Message-ID: <itkennet.6.0026A1B7_at_polyu.edu.hk>#1/1


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.

                     '"'
                    (_at_ @)
 ----------------ooO-(_)-Ooo-------------------+--------------------- 

| Kenneth YUEN | itkennet_at_smtpgwy.polyu.edu.hk|Phone:(852)2766-5370 |
| The H.K. PolyU| HungHom, Kln., Hong Kong. | Fax:(852)2356-7918 |
| | http://www.polyu.edu.hk | |
---------------+------------------------------+---------------------
Received on Thu Jan 25 1996 - 00:00:00 CET

Original text of this message