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.
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.
Oracle DatabaseSQL
Last Comment
slightwv (䄆 Netminder)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
In case you missed my post while you were typing:
set define off
set define off
ASKER
yes, I use sqlplus. Can I still set echo on?
Thanks.
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
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
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...
economics
info
global