, ,

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
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)
Share:
Read More
, , , ,

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

If you had already select a database you can only use
Show tables to show all the tables in the database. For ex. Select database MySql and in Sql command window enter following text

SHOW TABLES

And click on Run.

It will show all the tables which is avalible in the list
Share:
Read More