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!

Replace non numerics characters with 0

484216Jul 27 2007 — edited Jul 27 2007

Hi,
Can someone help me out with this?
I basically need to check my column value.
In case thr is an occurence of any non numeric character ,I need to replcae it with a 0.
By non numeric I mean any character other than [0-9].
For example 'rte$36^r'
I would like to convert it o '00003600'.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2007

Added on Jul 27 2007

2 comments

523 views