Re: Storing trailing zeros in mantissa

"Jeff Turner" <zigjst_at_hotmail.com> wrote in message news:c73aa58a.0308010604.2c1f4ca9_at_posting.google.com...
> I have a column defined as NUMBER(18,2) and want to store a value of,
> say, "10.20" in this column. Oracle returns the value to me as "10.2"
> instead of "10.20", but in my application (scientific in nature) there
> is a difference in "10.2" and "10.20".
>
> After browsing the ng's, it seems this is normal behavior in Oracle...
> Is this true? Does anyone know any magical "switches" I can flip to
> tell Oracle to store trailing zeros?
>
> Thanks,
> Jeff

Jeff

If you really need to store and be able to distinguish between 10.2 and 10.20
then you will have to store them as VARCHAR2s. As numeric values they are identical.

HTH eric

--
Remove the dross to contact me directly