Oracle Fundamentals (12) Math functions

Mathematical functions:

ABS (n): Seek absolute value

SELECT ABS (-),ABS(from DUAL;   -- get the absolute result of 15 :

Bitand (x, y): Returns x, Y for bitwise AND (and) results

SELECTBitand (1,0), Bitand (0,1), Bitand (0,0), Bitand (1,1), Bitand (1100,1010) fromDUAL;--returns the result of a bitwise and (and) operation on X, yResults:0,0,0,1, -

Ceil (n): Rounding up

SELECT Ceil (44.123), Ceil (-44.123 from dual;    -- Rounding up result: 

Floor (N): Rounding down

SELECT  Floor (44.567),Floor (-44.567 from dual;   -- Rounding down result: 

ROUND (m,n): Rounding

SELECT ROUND(44.567),ROUND(44.123),ROUND(-44.123),ROUND(-44.567) fromDual--RoundingResults: $, -,- -,- $SELECT Round(44.567,2) fromDual--rounded, reserved two decimal placesResults:44.57

TRUNC (m,n): Intercept

SELECTTRUNC (44.567), TRUNC (44.123), TRUNC (-44.123), TRUNC (-44.567) fromDual--truncateResults: -, -,- -,- -SELECTTRUNC (44.567,2) fromDual--truncateResults:44.56

Sign (n): Take symbol

SELECT  Sign (- from dual;       -- take a symbol, a positive number is 1, a negative number is -1,0 for 0 results:1

Sin (n): sine

SELECT SIN (3 from DUAL;      -- 3 sine result:0.141120008059867

COS (n): cosine

SELECT COS (3 from DUAL;      -- 3 cosine Result:-0.989992496600445

POWER (m,n): M's N times of Hades

SELECT POWER (2,8 from dual;    -- 2 of 8-square results:

SQRT (n): Open square root

SELECT SQRT (9 from dual;       -- Open square root result:3

MOD (m,n): Take surplus

SELECT MOD (3 from dual;     -- mod 2 (residual) results:1

Oracle Fundamentals (12) Math functions