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