16. orcle中replace的用法及例子

Posted on 2014-11-26 09:24  zkx4213  阅读(239)  评论(0编辑  收藏  举报

replace 函数用法如下:

replace('将要更改的字符串','被替换掉的字符串','替换字符串');

例子:

select  replace ('1,2,3',',',';') from dual;

输出为 '1;2;3'

Copyright © 2024 zkx4213
Powered by .NET 8.0 on Kubernetes