Can you please give me an example for the following task?
I need to extract the number after "thread" from the following string using regexp_substr in Oracle:
Archived Log entry 86041 added for thread 2 sequence 8100 ID 0xffffffff89e2d6df dest 1:
I was able to extract the first and the last number but not the one following the word thread.
I'd be glad for an example.