I will show how to round up a number by protecting 2 decimal. When I use round or ceil function, I can not have correct result. I want to round a number upwards with calculate 2 decimal.
I want result like below examples.
1.2445 > 1.25
1.21 > 1.21
1.521 > 1.53
1.1 > 1.1
You can use trunc function with add 0.009 to number.
Examples
select trunc(1.224 + 0.009,2) from dual;
1.23
select trunct(1.16 + 0.009,2) from dual;
1.16
select trunct(1.521 + 0.009,2) from dual;
1.53