Oracle and Numbers (Currency)
Posted on 2012-04-06
I am importing data from a csv that has numbers with currency. I am importing the columns as a number field but once the data is imported it is rounded off..
everything that is 0.50 becomes 1
should i be importing this data as varchar? it is going to be dealing with purely numbers with decimal places, i may need to end up with a number like 91.242879