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!

Script to replace non-numeric value of column to blank

Ketan BembiNov 10 2010 — edited Nov 10 2010

Hi

I want to replace non-numeric value of column to blank. Can any one help me out.
For example:

column1
------------------
234 kjnkj 12e
555565asd44
1232334343

Now I want to that update cloumn with blank value which contains non-numeric value in it

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2010

Added on Nov 10 2010

3 comments

397 views