version oracle 10g
SELECT REGEXP_REPLACE('ABC DEFG!@#$%&;.,)(*^EFG HIJKL','[^&;,][[:punct:]from dual;
Output
ABC DEFG&;,EFG HIJKL
i know i can do it like this
SELECT REGEXP_REPLACE ('ABC DEFG!@#$%&;.,)(*^EFG HIJKL','[!~`@#$%^*()-+=\|"''\.\from dual;
but just out of curiosity ... there should be an effecient way with out typing all special characters.
{code}
Thanks