SQLPlus Number/Character Formats
Posted on 2004-04-23
I’ve got a numeric field consisting of 2s, 1s and 0s in a table. I need to be able to sum the values and convert to a string but as soon as I convert the number to a string I get numbers of the form 1.0000000000000000000000000000000000E+44
I need numbers in a non scientific form so that I can take various substrings of the number.
I've tried using substr(field,0,46)
but none of these work
Can anyone help?