Hi,
I want to get rid or those special char in a number string to a pure number, for an instance, from 89_. or 99,9 to 89 and 999.
Which function should I use in SqlPlus?
Thanks a lot,
I want to get rid or those special char in a number string to a pure number, for an instance, from 89_. or 99,9 to 89 and 999.
Which function should I use in SqlPlus?
Thanks a lot,
Jack
Change nuber.+# to
number
