select replace ('111222333444','222','888') from dual;
with tmp as(
select 'aabb/123:cde工人' s from dual union all
select 'c*o"中国人刀k<j>aa|' from dual)
select s,translate(s,'$/:*?"<>|','$')from tmp;
select replace ('111222333444','222','888') from dual;
with tmp as(
select 'aabb/123:cde工人' s from dual union all
select 'c*o"中国人刀k<j>aa|' from dual)
select s,translate(s,'$/:*?"<>|','$')from tmp;