syntax to run update a column values with single quote in middle of column value..
could you please suggest me the syntax to run update a column values with single quote in middle of column value..
update bes.brc a set a.brc_NM = 'CUS04 HIGGSY'S CASINO' where a.brc_id = '00000529000120101125040446';
ERROR:
ORA-01756: quoted string not properly terminated
Thanks,
Kiran