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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement