How to replace part of string in a column, in oracle

Question

I am using oracle, toad.

I want to replace , with backspace.

Column consists of: bla bla foo ,CALL HELPDESK

It has to replace: bla bla foo CALL HELPDESK

Basically , should be removed

I tried like this:

UPDATE Mytable t
   SET column = REPLACE(t.U_MSG, ''%, CALL HELPDESK'', '% CALL HELPDESK')

Answer 1

REPLACE doesn't use wildcards, it simply replaces all instances of the first string with the second string. This should work:

UPDATE Mytable t
   SET column = REPLACE(t.U_MSG, ', CALL HELPDESK', ' CALL HELPDESK')