Re: Ingres to Oracle FLOAT DataType storage .....

LuckyBoy wrote:
> 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 ?

What is happening is that Ingres is not exporting as 85.67 but, probably due to some conversion factor, a different value. Output to a text file and look.

The solution is to use ROUND.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org