phone num cleanup
642141May 29 2008 — edited Jun 2 2008warning: total pl/sql newbie here!
Im needing to cleanup my phonenum column in the most efficient manner(146mil rows)
I'm thinking thats probably pl/sql...
dba suggested A function to rid the phone column of non-digits...
coming from a c and perl world, I just wanna walk the string char by char keeping only digits
then then update via something like this:
update table set phnum = cleanup(phnum) where phnum != cleanup(phnum)
I'll be darned if I cannot figure out howto walk a string and accomplish this...
your gracious assistance appreciated!