Usage of SQL Functions in Different Databases

MySQL, Oracle and MS SQL Server are different Relational Database Management Systems that widely used. SQL or Structured Query Language is the only language that used to communicate all the above three databases. MySQL and Oracle databases are maintained by Oracle where as Microsoft is taking care of MS SQL Server database. But we observed some difference in usage of functions all the three databases.

Oracle	MySql	SQLServer
SUBSTR	SUBSTRING	SUBSTRING
INSTR	LOCATE	CHARINDEX
LENGTH	LENGTH	LEN
Concat(\|\|)	Concat(\|\|)	Concat(+)
sysdate()	now()	getdate()
nvl	IFNULL	ISNULL
rownum	LIMIT	TOP

Comments

Photo : Savitri during her last days

Even after 4 decades of her death, people are very much interested to watched her (Savitri) biopic. Mahanati turned to be stupendous success. On eve of remembering Savitri, here we posted Savitri photo. The photo seems her last days. The man stand behind Savitri is Gemini Ganeshan who married Savitri. It seems that she suffered bad days during her last days.

Jagan angry on Avanthi Srinivas on Bhimili meeting!

Avanthi Srinivas was joined in YSRCP in January this year. Avanthi joined in YSRCP seeking to contest as Bhimili Assembly segment in 2019 General Elections.

Pawan Kalyan Dual stand on Mirchi issue in Telugu States!

Power Star Pawan Kalyan said again and again that he always raised the problems that existed in Two Telugu States. People from Telugu states too approached Pawan on their issues. Jana Sena President Pawan Kalyan issued a press note on Mirchi issues. It seems that Pawan questioning AP Government but silent on Telangana on Mirchi issues. Pawan Kalyan demand AP Government 11000/- as support price for Mirchi farmers. Pawan Kalyan linked Chandra Babu USA tour to Mirchi issues. Pawan compared that going other countries for investments is not much important than settling Mirchi issues. This indicates that Jana Sena President indirectly targeted CBN US tour. AP is offering highest price for Mirchi along with support price. On one side farmers from other states like Telangana, Maharashtra, Tamilnadu and Karnataka rushed to AP Market yards for selling their product. Mirchi issue started in Khammam where farmers agitated for not getting support price. Knowing this, Pawan Kalyan questioned C...

A2Z

Search This Blog