Scenario: To update string value of a table column based on search and replace.
update table_name
set column_name = replace(column_name, ‘oldname’, ‘newname’)
where column_name like ‘%oldname%’;
table_name – name of the table, column_name – name of the column, oldname – name to be replaced, newname – replacement string