The operation of databases from different manufacturers is similar, but there are many differences between them, even at level of SQL syntax.
For example, if you knows Oracle, and one day you have to do a date conversion with MySQL, you will wonder the following:
- How to do a TO_DATE () / TO_CHAR () with MySQL?
I open this blog entry to discuss different ways of doing things with each database type.
Here I link the SQL Tips Bristle Software , which explains quite well how to do some things with MySQL, Oracle and SQL Server, and I find especially useful the chapter on differences between Oracle and SQL Server
