Single Row Functions in Oracle

Number Functions:
These functions take Numeric values as input and returns numeric values. All the Number functions in oracle are listed in the given table.

S.no	Function	Description	Example
1	ABS(n)	Returns the Positive value of a given number	Abs(-4)= 4 Abs(4)=4 Abs(-3.865)= 3.865
2	CEIL(n)	Returns the smallest integer greater than equal to the given number	Ceil(3.56)= 4 Ceil(3.12)= 4 Ceil(-2.34)= -2
3	FLOOR(n)	Returns the largest integer less or equal to n.	Floor(2.34)= 2 Floor(-2.34)= -3
4	MOD(m, n)	Returns m modulo n, or the reminder of m divided n.	Mod(3,2)= 1
5	POWER(m, n)	Returns m raised to the nth power	Power(9,2)= 81
6	ROUND(m, n)	Returns ‘m ‘ rounded to ‘n’ digits of precision to the right of the decimal point. If n is negative, m is rounded to the left of the decimal point.	Round(3.86737, 4)= 3.8674 Round(3.86737, 2)= 3.87
7	SIGN(n)	Returns -1 if n is negative, 1 if n is positive, and 0 if n is zero.	Sign(-5346)= -1
8	SQRT(n)	Returns the square root of n	Sqrt(9)= 3
9	TRUNC(d, i)	Returns ‘d ‘ truncated to ‘i ‘ digits of precision to the right of the decimal point. If ‘i ‘ is negative, ‘d’ is truncated to the left of the decimal point.	Trunc(3.5642,2)= 3.56
10	Exp(n)	E raised to the nth power	Exp(2)= 7.3890561

Share on Google Plus

About siddu