Oracle UPDATE statement using the `REPLACE` function

The query should look something like:

UPDATE table1SET column1 = REPLACE(column1, '14', ' '),    column2 = REPLACE(column2, '14', ' ')WHERE column1 LIKE '%14%' OR column2 LIKE '%14%'

sql oracle syntax sql-update

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

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

CodeHunter