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

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

Function - Smallest integer >= value
Oracle - CEIL
SQL Server - CEILING

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

Function - Hyperbolic cosine
Oracle - COSH
SQL Server - COT

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

Function - Logarithm, any base
Oracle - LOG(N)
SQL Server - N/A

Function - Logarithm, base 10
Oracle - LOG(10)
SQL Server - LOG10

Function - Modulus (remainder)
Oracle - MOD
SQL Server - USE MODULO (%) OPERATOR

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

Function - Random number
Oracle - N/A
SQL Server - RAND

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

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

Function - Truncate
Oracle - TRUNC
SQL Server - N/A

Function - Highest number in list
Oracle - GREATEST
SQL Server - N/A

Function - Lowest number in list
Oracle - LEAST
SQL Server - N/A

Function - Convert number if NULL
Oracle - NVL
SQL Server - ISNULL

Function - Standard deviation
Oracle - STDDEV
SQL Server - STDDEV

Function - Variance
Oracle - VARIANCE
SQL Server - VAR

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

Visit Part II (String Functions)

## How to get tables names in MySql (sysobjects in sql server)

In Sql server we have a table sysobjects which holds names of all the tables i.e. system and user tables.

Like the same we have command “Show tables” which show all the tables of specified database.

Syntax
Show Tables from <databasename>

Here is an example.
SHOW TABLES FROM MySql