MySQL vs. Oracle

* Unlike oracle, mysql data types can store invalid dates and don’t support time zones.
* Transactions are better supported in Oracle as compared to Mysql. ROLE feature is available in Oracle and not in MySQL in versions less than 5.0
* Large Database size is supported more in Oracle in contrast to MySql.
* Replication in oracle is two way while one way in mysql.