Swaminathan K
asked on
Oracle round function
Hi Team,
I need an clarification , I have the below output , i want to know why oracle does not a number when i pass round(1.46) to 2 .
1* select round(1.46) , round(1.56) ,round(1.5), round(1.6) from dual
SQL> /
ROUND(1.46) ROUND(1.56) ROUND(1.5) ROUND(1.6)
----------- ----------- ---------- ----------
1 2 2 2
In the above output , oracle round the number the number to 2 for all the round options except for round(1.46). Any reason why oracle iis not rounding it to 2?
I need an clarification , I have the below output , i want to know why oracle does not a number when i pass round(1.46) to 2 .
1* select round(1.46) , round(1.56) ,round(1.5), round(1.6) from dual
SQL> /
ROUND(1.46) ROUND(1.56) ROUND(1.5) ROUND(1.6)
----------- ----------- ---------- ----------
1 2 2 2
In the above output , oracle round the number the number to 2 for all the round options except for round(1.46). Any reason why oracle iis not rounding it to 2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER