<div>
Are you looking for everything after the colon? &nbsp;That would be:<br />
<br />
substr(your_column, instr(your_column, ':')+1)<br />
<br />
Or, do you need to check that it is all numbers?
</div>


Are you looking for everything after the colon?  That would be:

substr(your_column, instr(your_column, ':')+1)

Or, do you need to check that it is all numbers?

<div>
is the colon variable? &nbsp;that is, could it be some other delimiter?<br />
if the number you want is always the end of the string then try this...<br />
<br />
regexp_substr(your_string,<wbr />'[0-9]+$')<wbr />
</div>


is the colon variable?  that is, could it be some other delimiter?
if the number you want is always the end of the string then try this...

regexp_substr(your_string,'[0-9]+$')

<div>
and regexp_substr(SQL_BIND,'[0<wbr />-9]+$')=NV<wbr />L(TO_NUMBE<wbr />R(:P_emp_n<wbr />o),emp.emp<wbr />no)<br />
passing as parameter and trying where clause not returning any rows<br />
but if i enter <br />
<br />
regexp_substr(SQL_BIND,'[0<wbr />-9]+$')='1<wbr />001' then returning rows of empno 1001.<br />
tried to convert to char but no use.<br />
please advise.
</div>


and regexp_substr(SQL_BIND,'[0-9]+$')=NVL(TO_NUMBER(:P_emp_no),emp.empno)
passing as parameter and trying where clause not returning any rows
but if i enter

regexp_substr(SQL_BIND,'[0-9]+$')='1001' then returning rows of empno 1001.
tried to convert to char but no use.
please advise.

<div>
<div class="content wysiwyg-content">
hi,<br />
can &nbsp;you please advise how can i get the number part from the following string.<br />
<br />
value<br />
<br />
&nbsp;#1(4):1589<br />
<br />
i want to extract and check in where condition only the number that 1589 after :<br />
thanks.
</div>
</div>


hi,
can  you please advise how can i get the number part from the following string.

value

 #1(4):1589

i want to extract and check in where condition only the number that 1589 after :
thanks.

oracle query

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.