Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the ROUND function with FLOAT types
Message
From
19/11/2001 21:02:07
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
 
General information
Forum:
Oracle
Category:
PL/SQL
Miscellaneous
Thread ID:
00583614
Message ID:
00583728
Views:
26
HI Mark,
Thank you very much for answering. Ib fact, what I want to do is to import currency data (Sybase or SQL SERVER money datatype) into an Oracle table. I use an ETL tool to tranfer data from target money columns to float ones in Oracle. I use float since Oracle does not have a money or currency datatype. But, it seems that the float datatype can cause inprecision :

35.94 in SQL server or Sybase equals 35.9400000891 in Oracle. The only way I had it working is to ROUND(35.94) while transferring it into Oracle. I've searched in several newsgroup and books and it seems that the only way to resolve my problem (without the ROUND() fct) is to use NUMBER(n,p) datatype. This way, I am sure that Oracle will not insert other decimal after the two first one.

Thank you for your help,
Christian Cote
Previous
Reply
Map
View

Click here to load this message in the networking platform