<div>
Okay, I figured out that I may use this <br />
<br />

<pre><code id="code-20-38395022-1">REGEXP_SUBSTR(mystring, '[[:digit:]]+',2,2)</code></pre>
<br />
However, there are probably numerous other attempts that are interesting to learn. So please don't hesitate if you have a suggestion!
</div>


Okay, I figured out that I may use this



REGEXP_SUBSTR(mystring, '[[:digit:]]+',2,2)


However, there are probably numerous other attempts that are interesting to learn. So please don't hesitate if you have a suggestion!

<div>
you can use the posix class instead of range specifier in either of the solutions above
</div>


you can use the posix class instead of range specifier in either of the solutions above

<div>
Just what I needed! <br />
<br />
Thanks again sdstuber! Nice examples!<br />
<br />
Anything you don't have an answer for??? :-)
</div>


Just what I needed!

Thanks again sdstuber! Nice examples!

Anything you don't have an answer for??? :-)

<div>
examining a logfile can be cumbersome<br />
&gt;&gt;&nbsp;did you check table v$archived_log ?
</div>


examining a logfile can be cumbersome
>> did you check table v$archived_log ?

<div>
<div class="content wysiwyg-content">
Can you please give me an example for the following task?<br />
<br />
I need to extract the number after &quot;thread&quot; from the following string using regexp_substr in Oracle:<br />
<br />

<blockquote>
Archived Log entry 86041 added for thread 2 sequence 8100 ID 0xffffffff89e2d6df dest 1:
</blockquote>
<br />
I was able to extract the first and the last number but not the one following the word thread.<br />
<br />
I'd be glad for an example.<br />
<br />
Thank you
</div>
</div>


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.

Thank you

Regular Expression

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.

Regular Expressions

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.