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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

1,716 views

1 mention