Numeric functions in Oracle SQL
3shTech (trainings@trishtechnology.com) String Functions Group Functions Date Functions Conversion Functions Analytical Functions Numeric Functions Numeric functions accept numeric input and return numeric values. NUMERIC FUNCTIONS:- · ABS · SIGN · SQRT · MOD · NVL · POWER · EXP · LN · LOG · CEIL · FLOOR · ROUND · TRUNC · BITAND · GREATEST · LEAST · COALESCE 1) ABS: · Absolute value is the measure of the magnitude of value. · Absolute value is always a positive number. Syntax : – ABS (value) Example: – SQL>SELECT ABS (5), ABS (-5), ABS (0), ABS (null) FROM DUAL; 2) SIGN: · Sign gives the sign of a value. Syntax : – SIGN (value) Example: – SQL>SELECT SIGN (5), SIGN (-5), SIGN (0), SIGN (null), SIGN (0.5) FROM DUAL; 3) SQRT: · This will give the square