select replace (‘111222333444‘,‘222‘,‘888‘) from dual;with tmp as(select ‘aabb/123\:cde工人‘ s from dual union allselect ‘c*o"中国人刀k<j>aa|‘ from dual)select s,translate(s,‘$/\:*?"<>|‘,‘$‘)from tmp;
replace和translate的用法
原文：http://www.cnblogs.com/wglwgl/p/6206945.html
