<div>
if you might have multiple numeric values and you want them all...<br />
<br />
regexp_replace(yourstring,<wbr />'[^0-9]')<br />
<br />
<br />
<br />
for example D1-A2-JOIN3<br />
<br />
123
</div>


if you might have multiple numeric values and you want them all...

regexp_replace(yourstring,'[^0-9]')



for example D1-A2-JOIN3

123

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have the string like &quot;D1-A-JOIN&quot;. Here i have to only fetch the numeric value which is present in the string.<br />
<br />
In the above string the SQL should only return 1.<br />
<br />
Thanks
</div>
</div>


Hi,

I have the string like "D1-A-JOIN". Here i have to only fetch the numeric value which is present in the string.

In the above string the SQL should only return 1.

Thanks

Fetch only Numeric Value from the String?

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.