Remove special characters from string in SQL

Using regexp_replace function we can remove all special characters in sql.

Ex : This is/Elangovan@@Ragavan

In the above string we have two extra characters /@

select regexp_replace('This is/Elangovan@@Ragavan’, '( *[[:punct:]])', ' ') test_string from dual;

result : This is ElangovanRagavan