CEIL function examples SELECTCEIL(1.2)FROMDUAL;-- output : 2SELECTCEIL(1.5)FROMDUAL;-- output : 2SELECTCEIL(1.7)FROMDUAL;-- output : 2SELECTCEIL(1.99)FROMDUAL;-- output : 2SELECTCEIL(-1.2)FROMDUAL;-- output : -1
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i Example Let's look at some Oracle CEIL function examples and explore how to use the CEIL function in Oracle/PLSQL. For example: CEIL(32.65) Result: 33 CEIL(32.1) Result: 33 CEIL(32) Result: 32 CEIL(-32.65) Result: -32 CEIL...
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 1...
exp function floor function ln function log function log10 function pi function power function radians function random function round function sign function sine function square root function tangent function truncate function Additional Examples A Introduction to the SQL for Oracle NoSQL Database Shellce...
The function returns the same data type as the numeric data type of the argument. Pictorial Presentation of CEIL() function Example: The statement below returns 1562 which is the smallest integer value not less than the value specified (1561.75) in the argument. ...
This function takes as an argument any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. The function returns the same data type as the numeric data type of the argument. See Also: ...
Oracle Function-NEXT_DAY,TRUNC,ROUND,CEIL,SIGN 注意:国际通用的日期中;周末才是一个周的第一天 ROUND and TRUNC Date Functions next lists theformat modelsyou can use with theROUND and TRUNC date functions and the units to which they round and truncate dates. The default model,'DD', returns ...
The function returns NULL in the following cases: If either the timestamp or unit argument is set to NULL. If the input timestamp is not castable to TIMESTAMP type. Example 12-11 For airline passengers with reservation code 'LE6J4Z' to 'ZG8Z5N', print the routing information and ...
Oracle/ Oracle Database/ Release 23 SQL Language Reference Syntax Description of the illustration ceil_interval.eps Purpose CEIL(interval)returns the interval rounded up to the unit specified by the second argumentfmt, the format model. If the first argument is truncated to the units offmt, the...
exp function floor function ln function log function log10 function pi function power function radians function random function round function sign function sine function square root function tangent function truncate function Additional Examples A Introduction to the SQL for Oracle NoSQL Database Shellce...