Numerical Math Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Numerical Math Functions
  4. Select 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
SQL>