Oracle 替换字符串

update tbl_name
set col_name = replace(col_name,'替换前的字符串','替换后的字符串');