oracle函数之replace replace('将要更改的字符串','被替换掉的字符串','替换字符串'); select replace ('15800003368','2102','****') from tmall_tcmessage; 输出为 '158****3367'