How to handle precision of number data type
I have a table with a column VOL which is a number data type NUMBER(7,3). The value in the column gets populated with the code
MAX (NVL (0.493039/1000,
NVL ((82*82*82)/ 1000000000,0)))
Now problem is that whenever a the result of above snippet comes out with decimal places more than 3 that is suppose 0.0004 then the column gets populated with a value of 0. I need to set a default value of 0.1 into those columns which is coming to be 0 after the precision being done. Can you suggest me a way to do so?