Oracle SQL Tutorial Number Functions

In this video, overview of Oracle predefined Number functions is given.

SQL Used in the video given below.

ABS - Absolute function returns absolute value. i.e it returns positive value.

select abs(-18.9), abs(8.9), abs(0) from dual;

FLOOR and CEIL

For 10.2, floor returns value 10, ceil returns value 11

select floor(10.8), ceil(10.2) from dual;

ROUND
select round(10.8), round(10.49) from dual;

SELECT round(10.483,1) from dual;

select round(3548,-1),round(3548,-2),round(3548,-3) from dual;

select round(3568,-1),round(3568,-2),round(3268,-3) from dual;

MOD - returns me the remainder..

let's say 11 divided by 3, here the remainder is 2

select mod(12,3) from dual;

select sign (-10), sign (0), sign(10) from dual;

select power (6,2), sqrt(3) from dual;