可以自己写个函数吧,具体怎么写我还不会,你可以去查查建函数的语法实现起来应该不麻烦:SQL> SELECT REPLACE('abcdefghijklm',SUBSTR('abcdefghijklm',2,1),'tttt') as test FROM dual;TEST -------------------------------- attttcdefghijklm
replace可以替换指定字符串 如 select replace('12345','1','A') from dual; 返回 A2345 如果想替换指定位置如6-7替换为aaa 可以 select substr(mystr,1,6)||'aaa'||substr(mystr,8,length(mystr)-7) from dual
--------------------------------
attttcdefghijklm
如
select replace('12345','1','A') from dual;
返回
A2345
如果想替换指定位置如6-7替换为aaa
可以
select substr(mystr,1,6)||'aaa'||substr(mystr,8,length(mystr)-7)
from dual