REPLACE(expr, from_string, to_string) ... 將會置換"整個"from_string到"整個"to_string select replace('a1234bcd','123','xxx') from dual; result: axxx4bcd TRANSLATE(expr, from_string, to_string) ....將會置換from_string中字元到to_string中字元 select translate('a12bc34bcd','123','xxx') from dual; result: axxbcx4bcd