• Home
  • Oracle PL / SQL
  • Aggregate Functions
  • Analytical Functions
  • Char Functions
  • Constraints
  • Conversion Functions
  • Cursor
  • Data Type
  • Date Timezone
  • Hierarchical Query
  • Index
  • Insert Delete Update
  • Large Objects
  • Numeric Math Functions
  • Object Oriented Database
  • PL SQL
  • Regular Expressions
  • Report Column Page
  • Result Set
  • Select Query
  • Sequence
  • SQL Plus
  • Stored Procedure Function
  • Subquery
  • System Packages
  • System Tables Views
  • Table
  • Table Joins
  • Trigger
  • User Previliege
  • View
  • XML

CEIL « Numeric Math Functions « Oracle PL / SQL

  1. Oracle PL / SQL
  2. Numeric Math Functions
  3. CEIL
1.CEIL(x): Returns the smallest integer greater than or equal to x
2.CEIL: Returns the ceiling value (next highest integer above a number)
3.CEIL(-5.2)
4.CEILING() and FLOOR()
5.select ceil( 10.00000000001 ) from dual
6. select ceil( -1.99 )from dual;

java2s.com  | Email:info at java2s.com | © Demo Source and Support. All rights reserved.