Execute the below Query to extract numeric value from any string or Text:
1 2 3 |
select regexp_replace('fa-shopping-cart-787', '[^0-9]', '') as get_number_val from dual |
1 2 3 |
select regexp_replace('fa-shopping-cart-787', '[^0-9]', '') as get_number_val from dual |