Problem description: oracle, which is used to query the regexp_replace function, main purpose is to remove the non-numeric characters in the field after get numeric characters perform arithmetic operations, the field value can be any character of the combination of any order, mysql is not very familiar with, through the document had not found a similar function, don't need to write a function to process?

CodePudding user response:

Specify the rules to remove