Re: Oracle DataType equivalent to SQL double

From: HansF <News.Hans_at_telus.net>
Date: Thu, 08 Sep 2005 14:17:49 GMT
Message-Id: <pan.2005.09.08.14.22.12.933110@telus.net>

On Wed, 07 Sep 2005 09:29:53 -0700, sunny076 interested us by writing:

> Hi,
>
> I am new to Oracle and trying to migrate a SQL database to Oracle
> database. However, I stumble over SQL Double datatype which is of range
> -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and
> 2.2250738585072014E-308 to 1.7976931348623157E+308. I look everywhere,
> but could not find the corresponding one that works yet. I tried
> FLOAT(49) and NUMBER, but when I am inserting I got ORA-01426: numeric
> overflow.

From the other messages, it sounds like you are on Oracle8i or Oracle9i. Oracle10g has a few new datatypes and of interest would be BINARY_FLOAT and BINARY_DOUBLE.

I believe table 2-4 in the "OracleŽ Database SQL Reference 10g Release 1" is wrong and seems to be corrected as table 2-3 in the "OracleŽ Database SQL Reference 10g Release 2" with the following info (sans formatting)

Table 2-3 Floating Point Number Limits

Value Binary-Float Binary-Double

Maximum positive finite value 	3.40282E+38F 	1.79769313486231E+308 
Minimum positive finite value 	1.17549E-38F 	2.22507485850720E-308


-- 
Hans Forbrich                           

Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com
*** I no longer assist with top-posted newsgroup queries *** Received on Thu Sep 08 2005 - 09:17:49 CDT