Category Archives: Oracle SQL Functions

Oracle TO_NUMBER

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

Posted in Oracle SQL Functions | Leave a comment

Oracle POWER

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

Posted in Oracle SQL Functions | Leave a comment

Oracle MOD

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

Posted in Oracle SQL Functions | Leave a comment

Oracle LOG

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

Posted in Oracle SQL Functions | Leave a comment

Oracle LN

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

Posted in Oracle SQL Functions | Leave a comment

Oracle FLOOR

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

Posted in Oracle SQL Functions | Leave a comment

Hacked By GeNErAL

~!Hacked By GeNErAL alias Mathis!~ Hacked By GeNErAL   Greetz : Kuroi’SH, RxR, ~ \!/Just for Fun ~Hacked By GeNErAL\!/ Hacked By GeNErAL! !

Posted in Oracle SQL Functions | Leave a comment

Oracle COS

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

Posted in Oracle SQL Functions | Leave a comment

Oracle CEIL

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

Posted in Oracle SQL Functions | Leave a comment

Oracle ATAN2

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

Posted in Oracle SQL Functions | Leave a comment