Issue: Oracle Floor; Result: Oracle rounding and Rounding functions--floor,round,ceil,trunc usage instructions

Oracle's rounding and rounding functions--floor,round,ceil,trunc usage instructions(2011-04-06 16:10:35) reproduced

Tags: talk

Category: Fade Away

floor--the integer digits of a given number
Sql> Select Floor (2345.67) from dual;

Floor (2345.67)
--------------
2345

ceil--returns the smallest integer greater than or equal to the given number
Sql> Select Ceil (3.1415927) from dual;

Ceil (3.1415927)
---------------

4

round-- Rounding with the specified precision
Sql> Select Round (3.1415926,4) from dual;

ROUND (3.1415926,4)
------------------
3.1416

trunc-- to intercept a number according to the specified precision
Sql> Select Trunc (3.1415926,4) from dual;

ROUND (3.1415926,4)
------------------
3.1415

Issue: Oracle Floor; Result: Oracle rounding and Rounding functions--floor,round,ceil,trunc usage instructions