Special character elimination

 Special character elimination

--follwoing code to eliminate the special characters

SELECT REGEXP_REPLACE('@$$My%%Blog&&*()','[^[:alnum(inlove)'' '']', NULL) FROM dual;

--query to eliminate the special characters

SELECT  REGEXP_REPLACE('%%kr#($!@#is@hna','([[:punct:]])','') RESULT FROM dual;