Total PageViews

Monday, July 22, 2019

Extract numbers from the string with the help of Regexp_Replace


Suppose we have a requirement to fetch the number from an alphanumeric string, then Regexp_Replace function help to extract the number from the string.


String :- 12ZXC3ASD456FGH8TED63

Query:- SELECT regexp_replace('12ZXC3ASD456FGH8TED63','\D') FROM dual;

O/P:-      123456863

No comments:

Post a Comment