Oracle PL/SQL CEIL function example

摘要: The CEIL function round the specified number up, and return the smallest number that is greater than or equal to the specified number.

The CEIL function round the specified number up, and return the smallest number that is greater than or equal to the specified number.

CEIL function examples

SELECT CEIL(1.2) FROM DUAL; 		-- output : 2
SELECT CEIL(1.5) FROM DUAL; 		-- output : 2
SELECT CEIL(1.7) FROM DUAL; 		-- output : 2
SELECT CEIL(1.99) FROM DUAL;		-- output : 2
SELECT CEIL(-1.2) FROM DUAL; 		-- output : -1
SELECT CEIL(-1.5) FROM DUAL; 		-- output : -1
SELECT CEIL(-1.7) FROM DUAL; 		-- output : -1
SELECT CEIL(-1.99) FROM DUAL; 		-- output : -1
SELECT CEIL(15.1) FROM DUAL; 		-- output : 16
SELECT CEIL(99.001) FROM DUAL; 		-- output : 100
SELECT CEIL(-1.5) FROM DUAL;		-- output : -1
SELECT CEIL(-0.9) FROM DUAL;		-- output : 0

References

  1. CEIL Function :- Oracle official docs

上一篇: Oracle PL/SQL ATAN and ATAN2 function example
下一篇: Oracle PL/SQL FLOOR function example
 评论 ( What Do You Think )
名称
邮箱
网址
评论
验证
   
 

 


  • 微信公众号

  • 我的微信

站点声明:

1、一号门博客CMS,由Python, MySQL, Nginx, Wsgi 强力驱动

2、部分文章或者资源来源于互联网, 有时候很难判断是否侵权, 若有侵权, 请联系邮箱:summer@yihaomen.com, 同时欢迎大家注册用户,主动发布无版权争议的 文章/资源.

3、鄂ICP备14001754号-3, 鄂公网安备 42280202422812号