Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NUMBER Vs NUMBER(38)

Re: NUMBER Vs NUMBER(38)

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Tue, 24 Aug 1999 09:30:30 +0200
Message-ID: <7ptho0$q0u$1@oceanite.cybercable.fr>


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 <7ps905$j8s$1_at_nnrp1.deja.com>...
>
>
>Can someone give the difference between the 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 Tue Aug 24 1999 - 02:30:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US