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!

Delete Non Numeric Values

976439Dec 20 2012 — edited Dec 20 2012

Hi, I have a set of data within a table with a column called telephone_numbers. What I have noticed is that for some reason I have data in there that is not numerical values only i.e. LLSSUU. Is it possible to delete all non numerical values from this column?

The problem is I have over 1000 fields to go through and was wondering if there is a query that i can write.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2013

Added on Dec 20 2012

12 comments

1,038 views