select
replace(TRANSLATE(replace(replace('测**式a.;: ',']',''),'[',''),
regexp_replace(replace(replace('测**式a.;: ',']',''),'[',''),'[^0-9a-zA-Z[:space:]!@#$%^&*()_+{}|":;\?/.,><`~!@#¥%……&*()——+}{|”;:“《》?、。,、’【】\"]\" '),' ')
,' ','') from dual;
select
replace(TRANSLATE(replace(replace('测**式a.;: ',']',''),'[',''),
regexp_replace(replace(replace('测**式a.;: ',']',''),'[',''),'[^0-9a-zA-Z[:space:]!@#$%^&*()_+{}|":;\?/.,><`~!@#¥%……&*()——+}{|”;:“《》?、。,、’【】\"]\" '),' ')
,' ','') from dual;