mysql in Comparison of Oracle

Thanks Satyapriya

Hi Arjun,

• 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.

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.

Refer

http://www.interview-guide.com/database/what-are-the-limitations-of-mysql-in-comparison-of-oracle/


Thanks