Numeric Math Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Numeric Math Functions
  4. 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>