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