'123-456, for example, the' matching '123', '123 -', '123-456, but does not match the' 1 ', '123-4'

CodePudding user response:

Hypothesis main string is A substring is B, I tried the following statement:
Select * from dual where '| | regexp_replace (A,' [^ 0-9] ', ') | | 'like' % '| | B | |' % '
Ok, when B is composed of pure digital meet other conditions or not