Numeric Math Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Numeric Math Functions
  4. Round(345 678), ceil(345 678), floor(345 678)
SQL>
SQL> select round(345.678), ceil(345.678), floor(345.678)
  2  from   dual;
ROUND(345.678) CEIL(345.678) FLOOR(345.678)
-------------- ------------- --------------
           346           346            345