PL/SQL (MOSC)

MOSC Banner

syntax to run update a column values with single quote in middle of column value..

edited Dec 4, 2013 2:54AM in PL/SQL (MOSC) 1 commentAnswered ✓
Hi team,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center