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

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

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

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

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

Posted in Oracle SQL Functions | Leave a comment

Oracle FLOOR

Function Description Function FLOOR returns largest integer equal to or less than argument. Examples

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

Posted in Oracle SQL Functions | Leave a comment

Oracle CEIL

Function Description Function CEIL returns smallest integer greater than or equal to argument. Examples

Posted in Oracle SQL Functions | Leave a comment

Oracle ATAN2

Function Description Function ATAN2 returns the arc tangent of two arguments. Examples

Posted in Oracle SQL Functions | Leave a comment