17,082
社区成员
发帖
与我相关
我的任务
分享
STR
01.02!01.02.01!01.02.01.01
select replace(
wmsys.wm_concat(substr(str,1,instr(str,'01')-1)||'01.02'||substr(str,instr(str,'01')+2))
,',','!') str
from
(select REGEXP_SUBSTR('01!01.01!01.01.01', '[^!]+', 1, LEVEL) STR
from dual
CONNECT BY LEVEL <= REGEXP_COUNT('01!01.01!01.01.01', '!') + 1)