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

Home -> Community -> Usenet -> c.d.o.server -> Ingres to Oracle FLOAT DataType storage .....

Ingres to Oracle FLOAT DataType storage .....

From: LuckyBoy <accentrahulsai_at_gmail.com>
Date: Tue, 23 Oct 2007 06:52:15 -0700
Message-ID: <1193147535.044375.8920@k35g2000prh.googlegroups.com> 





Hi I have a problem wherein I am getting the Data in Ingres, a FLOAT
(Length 4) coming in Oracle as 13 significant digits after decimal
i.e.


In Ingres : FieldName FLOAT(4) has data value (say) : 85.67
In Oracle (when pulled from Ingres and put in Oracle) : FieldName
FLOAT (Float 126) stores the data value as : 85.67544562345



any idea why this is happening and what is the solution ?
Received on Tue Oct 23 2007 - 08:52:15 CDT












Original text of this message













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