Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Round Demo

SQL> SQL> SELECT ROUND(1234.5678, 4) FROM DUAL; ROUND(1234.5678,4) ------------------          1234.5678 SQL> SELECT ROUND(1234.5678, 3) FROM DUAL; ROUND(1234.5678,3) ------------------           1234.568 SQL> SELECT ROUND(1234.5678, 2) FROM DUAL; ROUND(1234.5678,2) ------------------            1234.57 SQL> SELECT ROUND(1234.5678, 1) FROM DUAL; ROUND(1234.5678,1) ------------------             1234.6 SQL> SELECT ROUND(1234.5678, 0) FROM DUAL; ROUND(1234.5678,0) ------------------               1235 SQL> SELECT ROUND(1234.5678, -1) FROM DUAL; ROUND(1234.5678,-1) -------------------                1230 SQL> SELECT ROUND(1234.5678, -2) FROM DUAL; ROUND(1234.5678,-2) -------------------                1200 SQL> SELECT ROUND(1234.5678, -3) FROM DUAL; ROUND(1234.5678,-3) -------------------                1000 SQL>