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!

Extract Decimal number from varchar column

User_365D7Feb 23 2022 — edited Feb 23 2022

Hi All,

I'm trying the sum values from varchar column but this throws me an error with Invalid number ?

Can i know we can extract number from below examples?

123,
123abc
.123%
I tried using regexp_substr(strng1, '\.*[[:digit:]]+\.*[[:digit:]]*') but tomy luck it fails to sum the column any inputs appreciated?

TIA

Added on Feb 23 2022

9 comments

2,049 views

1 mention