21-Difference-Between-Oracle-And-MySQL.md

DIFFERENCE BETWEEN ORACLE & MYSQL

Definition

Oracle and MySQL are Relational Database Management Systems (RDBMS) used to store, manage, and retrieve data. The following table highlights the differences between Oracle and MySQL based on the handwritten notes.

---

Oracle vs MySQL

Oracle	MySQL
User cannot create multiple databases. There is only a single database.	User can create multiple databases.
We cannot insert multiple rows in a single INSERT statement.	We can insert multiple rows in a single INSERT statement.
Date format: DD-MM-YYYY	Date format: YYYY-MM-DD
NULL is represented by '-' symbol.	NULL is represented by NULL keyword.
Standard alphanumeric datatype is VARCHAR2(size).	Standard alphanumeric datatype is VARCHAR(size).
Data in the table is case sensitive.	Data in the table is not case sensitive.

---

Comparison Table

Feature	Oracle	MySQL
Number of Databases	Single Database	Multiple Databases
Multiple Row Insert	Not Supported in Single INSERT	Supported
Date Format	DD-MM-YYYY	YYYY-MM-DD
NULL Representation	'-' Symbol	NULL Keyword
String Datatype	VARCHAR2(size)	VARCHAR(size)
Case Sensitivity	Case Sensitive	Not Case Sensitive

---

Summary

Database	Description
Oracle	Enterprise RDBMS with advanced features and single database architecture.
MySQL	Open-source RDBMS that supports multiple databases and is widely used for web applications.