Category Archives: Oracle SQL Functions

Function Description Oracle function TO_NUMBER returns argument x in NUMBER datatype. Optional input arguments are Oracle format elements and nls language. Here you will find Oracle format elements with examples. Examples SELECT TO_NUMBER(‘555’) FROM dual; Result: 555 SELECT TO_NUMBER(‘555.12’) FROM dual; … Continue reading →

Function Description Function POWER returns x raised to the y power. If argument x is negative then argument x MUST be an integer. Examples SELECT POWER(2, 2) FROM dual; Result: 4 SELECT POWER(-2, 3) FROM dual; Result: -8 SELECT POWER(2, … Continue reading →

Function Description Function MOD returns the remainder of argument x divided by argument y. Oracle function MOD is calculated as x – y * FLOOR(x/y) Examples SELECT MOD(10, 2) FROM dual; Result: 0 SELECT MOD(10, 3) FROM dual; Result: 1 … Continue reading →

Function Description Function LOG returns the logarithm of x base y. Argument x MUST be greater than 0 or 1. Examples SELECT LOG(2, 10) FROM dual; Result: 3,32192809488736 SELECT LOG(10, 10) FROM dual; Result: 1 SELECT LOG(10, 250) FROM dual; … Continue reading →

Function Description Function LN returns the natural logarithm of argument. Argument MUST be greater than 0. Examples SELECT LN(2.4) FROM dual; Result: 0,8754687373539 SELECT LN(40) FROM dual; Result: 3,68887945411394 SELECT LN(0.1) FROM dual; Result: -2,30258509299405

Function Description Function FLOOR returns largest integer equal to or less than argument. Examples SELECT FLOOR(2.4) FROM dual; Result: 2 SELECT FLOOR(2.9) FROM dual; Result: 2 SELECT FLOOR(2) FROM dual; Result: 2

Function Description Function EXP returns e to the nth power, where e = 2,718281828. Examples SELECT EXP(2) FROM dual; Result: 7,38905609893065 SELECT EXP(1) FROM dual; Result: 2,71828182845905 SELECT EXP(-2.5) FROM dual; Result: 0,0820849986238988

Function Description Function COS returns the cosine of the argument n. The function returns the same datatype as the argument. Examples SELECT COS(-1) FROM dual; Result: 0,54030230586814 SELECT COS(-0.5) FROM dual; Result: 0,877582561890373 SELECT COS(2) FROM dual; Result: -0,416146836547142

Function Description Function CEIL returns smallest integer greater than or equal to argument. Examples SELECT CEIL(10) FROM dual; Result: 10 SELECT CEIL(10.2) FROM dual; Result: 11 SELECT CEIL(10.9) FROM dual; Result: 11

Function Description Function ATAN2 returns the arc tangent of two arguments. Examples SELECT ATAN2(0.5, 0.5) FROM dual; Result: 0,785398163397448 SELECT ATAN2(0.7, 0.7) FROM dual; Result: 0,785398163397448