Replace quotes from strings

Summary
In case you have a string, for example test'rt''45kj and you want to remove the quotes

select translate(translate(:your_string,'''', ' '),'"', ' ') from dual;
select replace(replace (:your_string,'''', ' '), '"', ' ') from dual;