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 -> Oracle DataType equivalent to SQL double

Oracle DataType equivalent to SQL double

From: <sunny076_at_yahoo.com>
Date: 7 Sep 2005 09:29:53 -0700
Message-ID: <1126110593.288225.136410@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
Received on Wed Sep 07 2005 - 11:29:53 CDT












Original text of this message













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