Tag: Ceil function SQL

• July 15, 2012

  Ceil function Oracle

  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 […]