Skip to content
Related Articles

Related Articles

Difference between Oracle and MySQL
  • Difficulty Level : Easy
  • Last Updated : 24 Jul, 2020

1. Oracle :
Oracle is a relational database management system (RDBMS). It was developed by Oracle Corporation in 1980. It is the first database designed for grid computing that provides the most flexible and cost-effective way to manage information and application. It runs on major platforms like Windows, Unix, Linux, and macOS. It is a relational database in which data is accessed by user through application or query language called SQL.

2. MySQL :
MySQL is an open source Relational Database Management System (RDBMS) based on Structured Query Language (SQL). It runs on platforms like Linux, UNIX and Windows.


Difference between Oracle and MySQL :

S.NO. Oracle MySQL
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.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

My Personal Notes arrow_drop_up
Recommended Articles
Page :