-1

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

pedroisp
  • 3
  • 2
  • Welcome! "_I've been on this stress all afternoon_" Note: [Under what circumstances may I add "urgent" or other similar phrases to my question, in order to obtain faster answers?](//meta.stackoverflow.com/q/326569/11107541) (just in case you were hoping to get an answer very quickly). See also [/help/no-one-answers](/help/no-one-answers). – starball Jan 10 '23 at 20:32
  • Could you please [read about why 'Can somebody help me?' is not really a question by our community's standards](//meta.stackoverflow.com/a/284237/11107541) and [edit] to apply what you learn to ask your question? You can also see [ask] for further guidance. For example, a better question might look like: "_What is the cause of , and how can the problem be resolved to get ?_" – starball Jan 10 '23 at 20:34

1 Answers1

0

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?

Ismail Müller
  • 395
  • 1
  • 7