I need to perform an UPDATE on the database, but within that update there is a section that has ' ' (single quotes), because of these quotes when running the error script, can anyone help me?

enter image description here

I've been on this stress all afternoon

CodePudding user response：

You can use 2 single quotes for that :

update galaxy
set sun = replace(sun, 'font ''Arial''', 'font ''Arial'' 12px')
where earth = 148;

see: PL/SQL, how to escape single quote in a string?