SQL Find and Replace to remove unwanted characters in a text field.

Hi,

Hope this is under the correct community, looked the most likely.

We have a requirement to remove certain characters such as -----, *****, ##### etc from a VARCHAR2 field.  It is 4000 bytes so contains lots of text and can have a number of the aforementioned characters in differing numbers within the text.

We need to remove the characters to just a single entry or altogether from the field without affecting the actual text.

Would look to do this with a sql script for each type using update but wondered if there is a find and replace type tool/option that would make the job easier.