Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

CEILING() and FLOOR()

SQL> Syntax: CEIL(<numeric expression>)     FLOOR(<numeric expression>) SQL> SQL> SELECT   2     CEIL(109.19)  ceil_val,   3     FLOOR(109.19) floor_val from dual;   CEIL_VAL  FLOOR_VAL ---------- ----------        110        109