please have a look at below SQL statement, it is working fine as required, but is there any problem i failed to understand to handle or any better way to achieve.
round to 10 ( forward and/or backward)
with dt as (Select 247 num from dual),
et as (select num, num - floor(num/10)*10 nums from dt)
select case when et.nums > 5 then
floor(et.num/-10)*-10
else
floor(et.num/10)*10
end results
from et;
this will result as: 250 --rounded to forward 10--
here CASE's first condition matched " et.nums > 5 "
regards