• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / CEIL Function in Oracle SQL – PLSQL

CEIL Function in Oracle SQL – PLSQL

November 5, 2012 by techhoneyadmin

The CEIL function in Oracle SQL / PLSQL is used to get a smallest integer number which is greater than or equal to the number passed to the function.

Syntax for the CEIL function in Oracle SQL / PLSQL is:

SELECT CEIL(N)
FROM table_name;

  • N is the number passed

Example 1:

SELECT CEIL(1.23456)
FROM DUAL;

Will return “2”


Example 2:

SELECT CEIL(2.2)
FROM DUAL;

Will return “3”


Example 3:

SELECT CEIL(2.051)
FROM DUAL;

Will return “3”


Example 4:

SELECT CEIL(-2.051)
FROM DUAL; 

Will return “-2”


Filed Under: function Tagged With: CEIL (ceiling) function in oracle plsql, CEIL (ceiling) function in oracle sql, CEILPLSQL, how to use CEIL (ceiling) function in oracle database query, how to use CEIL (ceiling) function in oracle plsql, how to use CEIL (ceiling) function in oracle sql, syntax and example of CEIL (ceiling) function in oracle database query, syntax and example of CEIL (ceiling) function in oracle plsql, syntax and example of CEIL (ceiling) function in oracle sql, using CEIL (ceiling) function in oracle database query, using CEIL (ceiling) function in oracle plsql, using CEIL (ceiling) function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in