摘要: 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 阅读全文
posted @ 2011-06-22 17:16 魔豆 阅读(449) 评论(0) 推荐(0) 编辑