反向索引去汉字符号

select translate('+861059602775(总机)','\'||translate('+861059602775(总机)','0123456789','\'),'\')
from dual

原文地址:https://www.cnblogs.com/tracy/p/2081630.html