<div>
Hi Rgonzo1971,<br />
<br />
please send me articles/videos related regular expression
</div>


Hi Rgonzo1971,

please send me articles/videos related regular expression

<div>
You could try<br />
<br />
<a href="https://www.youtube.com/watch?v=c-Ov1JUMDv4" rel="ugc">https://www.youtube.com/watch?v=c-Ov1JUMDv4</a><br />
it's a different flavor but the basics are there<br />
<br />
syntax for oracle<br />
<a href="http://www.techonthenet.com/oracle/functions/regexp_substr.php" rel="ugc">http://www.techonthenet.com/oracle/functions/regexp_substr.php</a><br />
<br />
You can test your regex in <br />
<a href="https://regex101.com/" rel="ugc">https://regex101.com/</a>
</div>


You could try

https://www.youtube.com/watch?v=c-Ov1JUMDv4 [https://www.youtube.com/watch?v=c-Ov1JUMDv4]
it's a different flavor but the basics are there

syntax for oracle
http://www.techonthenet.com/oracle/functions/regexp_substr.php [http://www.techonthenet.com/oracle/functions/regexp_substr.php]

You can test your regex in
https://regex101.com/ [https://regex101.com/]

<div>
<div class="content wysiwyg-content">
This is my string &nbsp;'chandra12[123]sekhar'<br />
<br />
<br />
o/p:- 123
</div>
</div>


This is my string  'chandra12[123]sekhar'


o/p:- 123

how to extract number from string using regular expressions in oracle

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.