Oracle UPDATE statement using the `REPLACE` function

Question

I am trying to remember how form a proper REPLACE statement in Oracle SQL.

In essence, I need to perform a REPLACE over a few thousand records in which column1 and column2 may contain a value of '14'. If they do, I need to replace it with just a space character.

I know that the syntax is something like the following, but I can't seem to get it quite right:

UPDATE TABLE
SET ('column1', 'column2') = REPLACE(?????????????)
WHERE 'column1' IN ('14') AND 'column2' NOT LIKE ('4%')

Any help would be appreciated.

Answer 1

UPDATE TABLENAME
  SET COLUMN1 = ' ',
  SET COLUMN2 = ' '
WHERE COLUMN1='14' OR COLUMN2='14';

Assuming Column[1,2] are of Character type.