Differences between Oracle database and MySQL database

OracleDatabases andMySQLThe difference between databases is what we will introduce in this article. Next we will introduce this part of content, hoping to help you.

Differences between Oracle and MySQL:

1. in Oracle, select * from all_users is used to display all users, while the command for displaying all databases in MYSQL is show databases. For my understanding, an Oracle project should have a user and a tablespace corresponding to it, while a MYSQL project should also have a user and a database. In ORACLE (same for db2), tablespaces are logical representations of physical containers in the file system. Views, triggers, and stored procedures can also be stored in tablespaces. MYSQL does not use tablespaces for management.

2. query all current tables. ORACLE: select * from tab, MYSQL: show tables.

3. Change the connected user (database ). ORACLE: conn username/password @ host string, MYSQL: use Database Name.

4. The current connected user (database) is displayed ). ORACLE: show user, MYSQL: connect.

5. Execute the external script command. ORACLE: @ a. SQL, MYSQL: source a. SQL.

The above is a comparison of the differences between the Oracle database and the MySQL database. I hope this introduction will be helpful to you!