update <table_name> set field_name = 'ABC' || chr(38) || 'DEF' where <where clause> 38 is the ASCII code for ampersand (&), and in this form it will be interpreted as a string, nothing else. I tried it and it worked.
I truly acknowledge and keep writing.This is an incredible moving post. I am practically satisfied with your great work. You put truly extremely supportive data. I am hoping to perusing your next post. Decontamination moisissure
I truly acknowledge and keep writing.This is an incredible moving post. I am practically satisfied with your great work. You put truly extremely supportive data. I am hoping to perusing your next post.
ReplyDeleteDecontamination moisissure