SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting "ORA-01722:Invalid Number" error while using regexp_replace

AB115Jul 22 2019 — edited Jul 23 2019

Hello Experts,

DB Version: 11.2.0.1

we have below select statement but when we execute, getting ORA-01722:Invalid number error,

select 1 from employee where salary in regexp_replace('1000:2000','[^0-9A-Za-z]',',');

we need to replace colon (:) with (,) for given 2 salaries.

please suggest.

Thanks

This post has been answered by Mustafa KALAYCI on Jul 23 2019

Jump to Answer

Added on Jul 22 2019

33 comments

2,818 views