Oracle data remove punctuation marks, as well as writing multiple replace form, how to use character table fit to delete, please answer

CodePudding user response:

The select translate (' asdf./"GHJKL ', ',./', ' ') from dual;
Select regexp_replace (' the as,./d: ' 'fg', '\ W', ') from dual;

CodePudding user response:

Regular expressions should be ok

CodePudding user response:

Translate to meet the requirements of the building Lord, it is quite appropriate,