Oracle and MY SQL Between Difference

MySQL	Oracle
MySQL is an open source and MySQL is available for free download and installation.	Only Oracle Express Edition is free of cost. But Oracle Express Edition has very limited features when compared to MySQL. For extensive features, either Oracle Standard Edition or Oracle Enterprise Edition has to be purchased.
User authentication is performed in MySQL by using only location, username and password.	Oracle provides enhanced database security. User authentication is performed in Oracle by specifying global roles in addition to location, username and password. In Oracle, User authentication is performed by different authentication methods including database authentication, external authentication and proxy authentication.
Flexibility of creating stored procedures and functions using PL/SQL is very less in MySQL.	Oracle provides more flexible features for creating stored procedures and functions using PL/SQL.
MySQL offers very few commands related to generating output as report and defining variables. MySQL includes only very simple SQL commands.	Oracle includes extensive SQL commands in SQL*Plus including commands for generating output as report and defining variables.
MySQL does not have the audit vault feature in the server.	Oracle provides audit vault facility.
MySQL does not offer tools at enterprise level.	Oracle offers tools at enterprise level.
MySQL has only table locking facility.	Oracle provides the row locking facility as well.
MySQL does not have extensive storage features like tablespace, synonym, packages and many others.	Oracle has a very extensive storage features. Oracle supports tablespace, synonym, packages and all other features.
MySQL database does not support XML.	Oracle supports and uses XML.
MySQL supports only two character types namely CHAR and VARCHAR.	Oracle supports four different character data types namely: CHAR, VARCHAR2, NCHAR, NVARCHAR2.
In MySQL, temporary tables are visible only within the current active session. When the session expires, the temporary tables are removed automatically.	In Oracle, temporary tables are persistent across sessions. The temporary table has to be explicitly removed by the User.
MySQL has only two backup mechanisms namely mysqlhotcopy and mysqldump.	Oracle offers many backup mechanisms including hot backup, backup, import, export and many others.

Similer…..
Java AND C++	Oracle and MY SQL
C++ and C#	C And C++
Asp and Jsp	ASP AND ASPX
Array and Stucture	Stucture and Union
Ajax And DHTML	Ajax And JQuery
Ajax AND JavaScript	Black Box Testing and White Box Testing
HTTP And HTTPS	GET And POST