Função - Remove caractere especial

create or replace function remove_char_esp(xvalor in varchar) return varchar2 deterministic is

begin

  return trim(replace(translate(xvalor,'_ = . [ ] ; > <  - / ! @ # $ % ¨ & * ( ) \ + { }',' '),' ',''));

end;

select remove_char_esp('Caracter (-@-) Especial!') from dual

CaracterEspecial