Oracle Numeric Functions ABS ,CEIL,FLOOR ,TRUNC,ROUND How to and Example Code

Oracle Numeric Functions ABS(number num)
Return absolute value of the number.

select abs(-1) from dual   -- return 1
select abs(1) from dual    -- return 1


Oracle Numeric Functions CEIL (number num)
Return Integer value that is Greater than or equal to the number

select CEIL(2.1) from dual;  -- return 3
select CEIL(2.5) from dual;  -- return 3
select CEIL(2.9) from dual;  -- return 3


Oracle Numeric Functions FLOOR (number num)
Return Integer value that is Less than or equal to the number

select FLOOR (2.1) from dual;  -- return 2
select FLOOR (2.5) from dual;  -- return 2
select FLOOR (2.9) from dual;  -- return 2


Oracle Numeric Functions TRUNC (number num1,number num2)
Return Truncates   value of number 'num1' up to 'num2' decimal places

select TRUNC(2.717) from dual;  -- return 2
select TRUNC(2.717,1) from dual; -- return 2.7
select TRUNC(2.717,2) from dual; -- return 2.71


Oracle Numeric Functions ROUND (number num1,number num2)
Return Rounded value of number 'num1' up to 'num2' decimal places

select ROUND (2.717) from dual;  --return 3
select ROUND (2.717,1) from dual; --return 2.7
select ROUND (2.717,2) from dual; --return 2.72