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.
mrongAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
using sqlplus?

set define off

Then do the update.
0
 
mrongAuthor Commented:
same message for the following strings.

economics
info
global
0
 
slightwv (䄆 Netminder) Commented:
In case you missed my post while you were typing:
set define off
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
mrongAuthor Commented:
yes, I use sqlplus. Can I still set echo on?
Thanks.
0
 
slightwv (䄆 Netminder) 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.
0
 
Geert GOracle dbaCommented:
or replace the & with chr(38)
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
You can also try setting the below :

Set define off
set scan off
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
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.
0
 
slightwv (䄆 Netminder) Commented:
"set define off" has already been posted.  Several times...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.