Expression Replace in Oracle SQL

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

>Solution :

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?

Leave a Reply