魔豆的BLOG

摘要： 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 阅读全文