Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

Specifying negative precision will round numbers on the left side of the decimal point, as shown here

SQL> SQL> SELECT ROUND(109.09 ,-1) rounded from dual;    ROUNDED ----------        110 SQL>