Ravindu Shantha Ravindu Shantha - 1 month ago 15
MySQL Question

Differences between MySQL and Oracle databases

What are the differences between MySQL and Oracle databases. I know both are RDBMS, both use SQL as Query language and both are developed by Oracle. So what are the differences between these two technically?

Answer

Mysql and Oracle are both RDMS. oracle not develop MySQL he purchase it. Both are same just syntax diffrence like for limit rows in mysql

select * from tbl limit 1

in oracle

SELECT * FROM tbl WHERE ROWNUM <=1;

mysql is open source and oracle is paid.for more diffrence in query you can see here

Comments