Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

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>