Oracle PL/SQL Tutorial/Numerical Math Functions/CEIL
Содержание
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>
