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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only