Oracle PL/SQL Tutorial/Numerical Math Functions/CEIL

Материал из SQL эксперт
Перейти к: навигация, поиск

CEIL(-5.2)

   <source lang="sql">

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


       -5</source>
   
  

CEIL(5.8)

   <source lang="sql">

SQL> select CEIL(5.8) from dual;

CEIL(5.8)

        6</source>
   
  

CEIL for negative value

   <source lang="sql">

SQL> SQL> SQL> -- create demo table SQL> create table myTable(

 2    id           NUMBER(2),
 3    value        NUMBER(6,2)
 4  )
 5  /

Table created. SQL> SQL> -- prepare data SQL> insert into myTable(ID, value)values (1,9)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (2,2.11)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (3,3.44)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (4,-4.21)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (5,10)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (6,3)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (7,-5.88)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (8,123.45)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (9,98.23)

 2  /

1 row created. SQL> SQL> select * from myTable

 2  /
       ID      VALUE

----------
        1          9
        2       2.11
        3       3.44
        4      -4.21
        5         10
        6          3
        7      -5.88
        8     123.45
        9      98.23

9 rows selected. SQL> SQL> SQL> SELECT id, value,CEIL(value) FROM myTable

 2  /
       ID      VALUE CEIL(VALUE)

---------- -----------
        1          9           9
        2       2.11           3
        3       3.44           4
        4      -4.21          -4
        5         10          10
        6          3           3
        7      -5.88          -5
        8     123.45         124
        9      98.23          99

9 rows selected. SQL> SQL> SQL> SQL> -- clean the table SQL> drop table myTable

 2  /

Table dropped. SQL> SQL></source>


CEIL(x) gets the smallest integer greater than or equal to x.

The following example uses CEIL() to display the absolute value of 5.8 and -5.2, respectively:



   <source lang="sql">

SQL> SELECT CEIL(5.8), CEIL(-5.2) FROM dual;

CEIL(5.8) CEIL(-5.2)

----------
        6         -5</source>
   
  

Use CEIL function to get the ceiling value

   <source lang="sql">

SQL> SQL> SQL> -- create demo table SQL> create table myTable(

 2    id           NUMBER(2),
 3    value        NUMBER(6,2)
 4  )
 5  /

Table created. SQL> SQL> -- prepare data SQL> insert into myTable(ID, value)values (1,9)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (2,2.11)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (3,3.44)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (4,-4.21)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (5,10)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (6,3)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (7,-5.88)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (8,123.45)

 2  /

1 row created. SQL> insert into myTable(ID, value)values (9,98.23)

 2  /

1 row created. SQL> SQL> select * from myTable

 2  /
       ID      VALUE

----------
        1          9
        2       2.11
        3       3.44
        4      -4.21
        5         10
        6          3
        7      -5.88
        8     123.45
        9      98.23

9 rows selected. SQL> SQL> SELECT id, value,CEIL(value) FROM myTable

 2  /
       ID      VALUE CEIL(VALUE)

---------- -----------
        1          9           9
        2       2.11           3
        3       3.44           4
        4      -4.21          -4
        5         10          10
        6          3           3
        7      -5.88          -5
        8     123.45         124
        9      98.23          99

9 rows selected. SQL> SQL> SQL> -- clean the table SQL> drop table myTable

 2  /

Table dropped. SQL> SQL></source>