Re: SQL Statement error

You have two options in SQL*Plus:

1. Set the system parameter 'DEFINE' to any character other than the ampersand. Then your string will be interpreted as is.
2. Set the system parameter 'SCAN' off. This disables all substitution, and all strings are interpreted as is.

Syed Rashid wrote:
>
> Can anyone tell me what do I have to do to make the following update
> statement to accept the "&" symbol in the first place. Is there anyway
> to automate this, so any sql statment will accept "&" in any field?
>
> SQL> update contact set cncompany = 'AB&D' where cncompid = 'cp9208'
> 2 ;
> Enter value for t: &D
> old 1: update contact set cncompany = 'AB&D' where cncompid = 'cp9208
> new 1: update contact set cncompany = 'AB&D' where cncompid = 'cp9208
>
> 1 row updated.
>
> Thanks much
> Syed Rashid
 

-- 
---------------------
Robert Christenson
robertoc_at_fyiowa.infi.net
The Gazette Co.