Oracle SQL - String replace

Updating String fields using the replace function:

update [table_name] set [field_being_updated]=replace([field_being_updated], '[string_to_be_replaced]', '[replacement_string]')