1. |
It is developed By Oracle in 1980. |
It is developed By Oracle in 1995. |
2. |
It is commercial. |
It is Open Source. |
3. |
Server operating systems for Oracle is AIX, HP-UX, Linux, OS X, Solaris, Windows, z/OS. |
Server operating systems for MySQL is FreeBSD, Linux, OS X, Solaris, Windows. |
4. |
Its Primary database model is a Relational DBMS. |
Its primary database model is also Relational DBMS. |
5. |
It has predefined data type such as date or float. |
It also has predefined data type such as date or float. |
6. |
It supports SQL. |
It also supports SQL. |
7. |
APIs and other access methods for Oracle is JDBC, ODBC, ODP.NET, Oracle Call Interface (OCI). |
APIs and other access methods for MySQL is ADO.NET, JDBC, ODBC, Proprietary native API. |
8. |
Programming languages supported by Oracle are C, C#, C++, Clojure, Cobol, Delphi, Eiffel, Erlang, Fortran, Groovy, Haskell, Java, JavaScript, Lisp, Objective C, OCaml, Perl, PHP, Python, R, Ruby, Scala, Tcl, Visual Basic. |
Programming languages supported by MySQL are Ada, C, C#, C++, D, Delphi, Eiffel, Erlang, Haskell, Java, JavaScript (Node.js), Objective-C, OCaml, Perl, PHP, Python, Ruby, Scheme, Tcl. |
9. |
It supports Server-side scripting using user PL/SQL. |
It also supports Server-side scripting. |
10. |
It supports Partitioning methods using horizontal partitioning. |
It supports Partitioning methods using horizontal partitioning, sharding with MySQL Cluster or MySQL Fabric. |