and if he wants to return it with a
fixed two decimal, all that's needed
is a mask function, no?
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"Eric Parker" <eric.parkerthedross_at_virgin.net> wrote in message
news:3GuWa.2608$Kx1.32702_at_newsfep4-glfd.server.ntli.net...
> "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
>
>
Received on Fri Aug 01 2003 - 09:48:55 CDT
