в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:55:09Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/Numeric Math Functions/CEIL - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия