摘要:
replace:字符串级别的代替 如:SELECT REPLACE('acdd','cd','ef') FROM dual; →aefd translate:字符级别的代替 如:SELECT TRANSLATE('acdd','cd','ef') FROM dual; →aeff 分别详解: replace: 语法:REPLACE ( char , search_string [, replacement_string] ) REPLACE returns char with every occur 阅读全文