what is difference between oracle & mysql ?

Key difference: The Oracle Database is an object-relational database management system (ORDBMS). MySQL is an open source relational database management system (RDBMS). MySQL is the world’s most used RDBMS, and runs as a server providing multi-user access to a number of databases.

 

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

About Hiren Kubavat

PHP Developer
This entry was posted in database, MysQl, oracle and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s