(occuranHi! Need some help. I'm trying to use regexp_substr to get number from string. But Oracle returns me NULL when I choose the second match.
INPUT STRING:
Line #255: 05:59:51.050639000 : start process fill 188234978
When I choose the first match (by default) - it returns:
start process fill 188234978
SQL:
select REGEXP_SUBSTR('Line #255: 05:59:51.050639000 : start process fill 188234978', '(start process fill )(\w+)',1,2)
from dual
Why?
Oracle Database 11.2.0.4.0 x64