I need to find the next 10 digit number in a query.
I try to use round(n,-1) but it rounds off to nearest 10 digit but I need next 10 digit.
Please help me.
select round(5834.6,-1) from dual
gives 5830 but i need 5840
select ceil(5834.6/10)*10 from dual
Then add "5":
select round(5834.6 + 5,-1) from dual
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With