What is the difference between oracle number data type and oracle floating data type? I want to create columns for salary and rate, what data type should be more comfortable for those columns.
Asked
Active
Viewed 53 times
1 Answers
0
Anything to do with money should probably be stored as a NUMBER type, as it is not prone to IEEE-type rounding errors. All arithmetic in a NUMBER type is essentially integer, so 1.5 * 1.5 will equal 2.25, not 2.249999999......
David Aldridge
- 51,479
- 8
- 68
- 96