We help IT Professionals succeed at work.

Urgent: Update query issue in Oracle 11g

mrong
mrong asked
on
Greeting,

I have update stmts like the following. When I ran it, it popup a message "Enter value for recreation: " 
What is it for? Any suggestions?

Update TBL1
set desc='ATHLETICS & RECREATION'
where id='005'

Thanks.
Comment
Watch Question

Most Valuable Expert 2012
Distinguished Expert 2019
Commented:
using sqlplus?

set define off

Then do the update.

Author

Commented:
same message for the following strings.

economics
info
global
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
In case you missed my post while you were typing:
set define off

Author

Commented:
yes, I use sqlplus. Can I still set echo on?
Thanks.
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
>>Can I still set echo on?

Yes.

Here is the online docs about the '&':
http://docs.oracle.com/cd/E11882_01/server.112/e16604/ch_five.htm

You can SET DEFINE OFF to prevent scanning for the substitution character.
Geert GOracle dba
Top Expert 2009

Commented:
or replace the & with chr(38)
Naveen KumarProduction Manager / Application Support Manager

Commented:
You can also try setting the below :

Set define off
set scan off
Naveen KumarProduction Manager / Application Support Manager

Commented:
I am aware that scan off is obsolete in the latest versions but just want you to try if in case the define off does not help for some reason.
Most Valuable Expert 2012
Distinguished Expert 2019

Commented:
"set define off" has already been posted.  Several times...