orcl中replace()用法:
replace:(字符串 | 列):进行替换;
将bqh1表中name列带“小”的字改成“大”:
select * from bqh1select a.*,replace(name,'小','大') from bqh1 a
本站QQ群:前端 618073944 | Java 606181507 | Python 626812652 | C/C++ 612253063 | 微信 634508462 | 苹果 692586424 | C#/.net 182808419 | PHP 305140648 | 运维 608723728