How to with oracle regexp_replace parse string

Question

I have a string: "ABC-30 (40D)", the result is 30, my example:

regexp_replace(f, '^[^-]+-(\d+)*')

don't work...

Answer 1

Use REGEXP_SUBSTR with this pattern.

SELECT regexp_substr('ABC-30 (40D)', '^[^-]+-(\d+)[^0-9]+.*$' , 1 ,1 , 'i', 1  ) FROM DUAL;