Re: Oracle DataType equivalent to SQL double

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 7 Sep 2005 19:04:57 +0200
Message-ID: <431f1db9$0$29501$636a15ce@news.free.fr>

<sunny076_at_yahoo.com> a écrit dans le message de news: 1126110593.288225.136410_at_g44g2000cwa.googlegroups.com...
| 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.
|
| I would appreciate if anyone can enlighten me.
|
| Sunny
|

You can't NUMBER (or FLOAT) Oracle datatype is in the range 1.0E-130 to (but not including) 1.0E126.

Regards
Michel Cadot Received on Wed Sep 07 2005 - 12:04:57 CDT