Monday, November 23, 2009

SQL Function Reference:Oracle vs.SQL Server vs. My SQL Part- I

1 comment
Generally the major issue we face while development is the availability of common functions in different database(s).

I am facing this issue from last so many years. Then I had start preparing a table for common functions of different database(s).

The commonly used databases are Oracle, Sql Server and My Sql. Their is so many other database(s) are also available but commonly I works on these database(s) only.

Following is the common list of functions in different database(s):-

Math Functions
Function - Absolute value
Oracle - ABS
SQL Server - ABS
My Sql - ABS

Function - Arc cosine
Oracle - ACOS
SQL Server - ACOS
My Sql - ACOS

Function - Arc sine
Oracle - ASIN
SQL Server - ASIN
My Sql - ASIN

Function - Arc tangent of n
Oracle - ATAN
SQL Server - ATAN
My Sql - ATAN

Function - Arc tangent of n and m
Oracle - ATAN2
SQL Server - ATAN2
My Sql - Please Suggest

Function - Smallest integer >= value
Oracle - CEIL
SQL Server - CEILING
My Sql - Please Suggest

Function - Cosine
Oracle - COS
SQL Server - COS
My Sql - COS

Function - Hyperbolic cosine
Oracle - COSH
SQL Server - COT
My Sql - Please Suggest

Function - Exponential value
Oracle - EXP
SQL Server - EXP
My Sql -EXP

Function - Round down to nearest integer
Oracle - FLOOR
SQL Server - FLOOR
My Sql -FLOOR

Function - Natural logarithm
Oracle - LN
SQL Server - LOG
My Sql - Please Suggest

Function - Logarithm, any base
Oracle - LOG(N)
SQL Server - N/A
My Sql - Please Suggest

Function - Logarithm, base 10
Oracle - LOG(10)
SQL Server - LOG10
My Sql - Please Suggest

Function - Modulus (remainder)
Oracle - MOD
SQL Server - USE MODULO (%) OPERATOR
My Sql - Please Suggest

Function - Power
Oracle - POWER
SQL Server - POWER
My Sql - POWER

Function - Random number
Oracle - N/A
SQL Server - RAND
My Sql - Please Suggest

Function - Round
Oracle - ROUND
SQL Server - ROUND
My Sql - ROUND


Function - Sign of number
Oracle - SIGN
SQL Server - SIGN
My Sql - SIGN

Function - Sine
Oracle - SIN
SQL Server - SIN
My Sql - SIN

Function - Hyperbolic sine
Oracle - SINH
SQL Server - N/A
My Sql - Please Suggest

Function - Square root
Oracle - SQRT
SQL Server - SQRT
My Sql - SQRT

Function - Tangent
Oracle - TAN
SQL Server - TAN
My Sql - TAN

Function - Hyperbolic tangent
Oracle - TANH
SQL Server - N/A
My Sql - Please Suggest

Function - Truncate
Oracle - TRUNC
SQL Server - N/A
My Sql - Please Suggest

Function - Highest number in list
Oracle - GREATEST
SQL Server - N/A
My Sql - Please Suggest

Function - Lowest number in list
Oracle - LEAST
SQL Server - N/A
My Sql - Please Suggest

Function - Convert number if NULL
Oracle - NVL
SQL Server - ISNULL
My Sql - Please Suggest

Function - Standard deviation
Oracle - STDDEV
SQL Server - STDDEV
My Sql - Please Suggest

Function - Variance
Oracle - VARIANCE
SQL Server - VAR
My Sql - Please Suggest

This is not the end of functions or post. I will post string and datetime functions in coming articles. :)

Visit Part II (String Functions)

1 comments:

Shakti Singh Dulawat said...

No word for narendra
he is doing great knowledge , nothing more than knowledge