Ceil function returns next whole number. It is a Numeric Function.
Syntax :-
CEIL(n) where n is a number
Examples :-
SQL> select ceil(1.1) from dual;
CEIL(1.1)
———-
2
SQL> select ceil(1) from dual;
CEIL(1)
———-
1
SQL> select ceil(-1.1) from dual;
CEIL(-1.1)
———-
-1
SQL> select ceil(-1) from dual;
CEIL(-1)
———-
-1
SQL> select ceil(0) from dual;
CEIL(0)
———-
0
SQL> select ceil(‘a’) from dual;
select ceil(‘a’) from dual
*
ERROR at line 1:
ORA-01722: invalid number
Note :- Argument must be a number
Advertisements
