Re: NUMBER Vs NUMBER(38)

That's not quite right - you can insert floating point values in a NUMBER(38) as well.
There is actually no difference as far as internal storage goes. The number 567 will consume the same amount of storage in both. It is more meaningful for the application
to indicate what the precision is, but both cases they contain 38 digits of precision.

Michel Cadot wrote:

> NUMBER is a floating point number with precision of about 38 digits
> in the ranges:
> range -9.9999999999999999999999999999999999999x10^125 to -1x10^-130 ;
> 0 ;
> range 1x10^-130 to 9.9999999999999999999999999999999999999x10^125
>
> NUMBER(38) is an integer of 38 digits max.
>
> Nandakumar a écrit dans le message <7ps95q$jhf$1_at_nnrp1.deja.com>...
> >Is there any difference between datatype declarations
> >NUMBER and NUMBER(38)?
> >--
> >Nandakumar
> >(N.Kumar_at_rocketmail.com)
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
Received on Wed Aug 25 1999 - 13:52:17 CDT