Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using the ROUND function with FLOAT types
Message
De
19/11/2001 21:02:07
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Québec, Canada
 
 
Information générale
Forum:
Oracle
Catégorie:
PL/SQL
Divers
Thread ID:
00583614
Message ID:
00583728
Vues:
28
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform