Hi Anjana,
Using translate function you can solve your problem.
See for example in your case (presently) only two special characters are present, so in translate add those special characters.

update test1 set name = ( select translate(name,'a$@','a') from temp)