oracle replace与translate的区别

来源:互联网 发布:淘宝如何手动上传 编辑:程序博客网 时间:2024/05/29 16:47

下面是在官网上摘抄下来的

translate只能是单个字符一对一的替换,replace是字符串的替换,并能删除

REPLACE provides functionality related to that provided by the TRANSLATE function. TRANSLATE provides single-character, one-to-one substitution.REPLACE lets you substitute one string for another as well as to remove character strings.

0 0