PL/SQL Ceil

Oracle PL/SQL Ceil Function

The Ceil function allows you to round up any number to the next integer.

The Ceil Function syntax:

ceil( number )

Example:

Select ceil(99.34) From dual;
100


Select ceil(99) From dual;
99


Select ceil(-99.34) From dual;
-99


Select ceil(-99) From dual;
-99