Skip to Main Content
Forums

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!

Remove all non-numeric values witout using Replace

2d6dd596-4458-46a5-9af4-6ae883ba3c7cSep 18 2015 — edited Sep 18 2015

Hi

I need to remove the numeric values and special character from the string value in Oracle SQL. My data looks like  100*$7. Without using replace, update set query i should get data like 1007.

Thanks,

Ramya
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 16 2015
Added on Sep 18 2015
4 comments
3,167 views