orcl中replace()用法:
replace:(字符串 | 列):进行替换;
将bqh1表中name列带“小”的字改成“大”:
select * from bqh1select a.*,replace(name,‘小‘,‘大‘) from bqh1 a
replace 用法
原文:https://www.cnblogs.com/su-root/p/9752018.html