Oracle PL/SQL/Numeric Math Functions/CEIL

CEIL(-5.2)

   <source lang="sql">

SQL> select CEIL(-5.2) from dual; CEIL(-5.2)

---

       -5

SQL> SQL>

      </source>
   
  

CEILING() and FLOOR()

   <source lang="sql">

SQL> Syntax: CEIL(<numeric expression>) FLOOR(<numeric expression>) SQL> SQL> SELECT

 2     CEIL(109.19)  ceil_val,
 3     FLOOR(109.19) floor_val from dual;
 CEIL_VAL  FLOOR_VAL

---

----------

      110        109
</source>
   
  

CEIL: Returns the ceiling value (next highest integer above a number)

   <source lang="sql">

SQL> SQL> SQL> -- create demo table SQL> create table TestTable(

 2    ID                 VARCHAR2(4 BYTE)         NOT NULL,
 3    MyName             VARCHAR2(10 BYTE),
 4    MyDate             DATE,
 5    MyNumber           Number(8,2)
 6  )
 7  /

Table created. SQL> SQL> SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19960711","YYYYMMDD"),12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("2","Jason",to_date("19970622","YYYYMMDD"),-12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("3","Smith",to_date("19980513","YYYYMMDD"),22.1); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("4","Tailor",to_date("19990624","YYYYMMDD"),-2.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("5","Darlene",to_date("20000415","YYYYMMDD"),2.1); 1 row created. SQL> SQL> SQL> select * from TestTable; ID MYNAME MYDATE MYNUMBER

---

---------- --------- ----------

1 Alison 11-JUL-96 12.12 2 Jason 22-JUN-97 -12.12 3 Smith 13-MAY-98 22.1 4 Tailor 24-JUN-99 -2.12 5 Darlene 15-APR-00 2.1 SQL> SQL> SQL> -- CEIL: Returns the ceiling value (next highest integer above a number). SQL> SQL> SQL> SQL> select MyNumber, CEIL(MyNumber) from TestTable;

 MYNUMBER CEIL(MYNUMBER)

---

--------------

    12.12             13
   -12.12            -12
     22.1             23
    -2.12             -2
      2.1              3

SQL> SQL> SQL> SQL> SQL> SQL> drop table TestTable; Table dropped. SQL> SQL> SQL>

      </source>
   
  

CEIL(x): Returns the smallest integer greater than or equal to x

   <source lang="sql">

SQL> --CEIL(x): Returns the smallest integer greater than or equal to x. SQL> SQL> select CEIL(5.8) from dual;

CEIL(5.8)

---

        6

SQL>

      </source>
   
  

select ceil( 10.00000rom dual

   <source lang="sql">

SQL> SQL> SQL> select ceil( 10.00000000001 ) from dual; CEIL(10.00000000001)

---

                 11

1 row selected. SQL> --

</source>
   
  

select ceil( -1.99 )from dual;

   <source lang="sql">

SQL> SQL> select ceil( -1.99 )from dual; CEIL(-1.99)

---

        -1

1 row selected. SQL> SQL> SQL> SQL> --

</source>