Some time you may have to round to 10,25,50,100 etc so here are few example hope would serve the purpose.
SQL> select round(nvl(173,0)/10,0)*10 from dual;
ROUND(NVL(173,0)/10,0)*10
-------------------------
170
SQL> select round(nvl(173,0)/25,0)*25 from dual;
ROUND(NVL(173,0)/25,0)*25
-------------------------
175
SQL> select round(nvl(173,0)/50,0)*50 from dual;
ROUND(NVL(173,0)/50,0)*50
-------------------------
150
SQL> select round(nvl(173,0)/100,0)*100 from dual;
ROUND(NVL(173,0)/100,0)*100
---------------------------
200
Rounding of different denominations (10,25,50,100)
-
- Posts: 25
- Joined: Fri Mar 31, 2006 4:49 pm
- Location: United Kingdom
Who is online
Users browsing this forum: No registered users and 0 guests