asked on
Single quote in Oracle update stmt
Greeting,
I have the following update query in Oracle. The single quote inside the update stmt(Clerk's) caused error. Any suggestions?
update TBL1
set desc='Clerk's Office'
where ID='005';
Thanks.
I have the following update query in Oracle. The single quote inside the update stmt(Clerk's) caused error. Any suggestions?
update TBL1
set desc='Clerk's Office'
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.
IOW the extra apostrophe is required to prevent literal strings from being mistaken as a field delimiter. Oracle allows the delimiter (quote) to become some other character, but that's a pain.
Forgot about this. You can use the 'q' syntax as well.
update TBL1
set desc=q'[Clerk's Office]'
where ID='005';
update TBL1
set desc=q'[Clerk's Office]'
where ID='005';