Link to home
Create AccountLog in
Avatar of mrong
mrong

asked on

Urgent: Update query issue in Oracle 11g

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.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of mrong
mrong

ASKER

same message for the following strings.

economics
info
global
In case you missed my post while you were typing:
set define off
Avatar of mrong

ASKER

yes, I use sqlplus. Can I still set echo on?
Thanks.
>>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.
or replace the & with chr(38)
You can also try setting the below :

Set define off
set scan off
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.
"set define off" has already been posted.  Several times...