Question

oracle中ceil命令怎么用?最好举个例子 谢谢！

Answer 1

select ceil(7.2) as cc from dual ;

cc
------
8

################################

In Oracle/PLSQL, the ceil function returns the smallest integer value that is greater than or equal to a number.

The syntax for the ceil function is:

ceil( number )

number is the value used to find the smallest integer value.

Applies To:

Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g
For Example:

ceil(32.65) would return 33.
ceil(32) would return 32.
ceil(-32.65) would return -32.
ceil(-32) would return -32.