Oracle 替换字符串

replace(strSource, str1, str2)将strSource中的str1替换成str2

• strSource：源字符串
• str1: 要替换的字符串
• str2: 替换后的字符串

select '替换字符串' as oldStr, replace('替换字符串', '替换', '修改') as newStr from dual