Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

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