•Installation • Structure • Run it • Credits

1. Download and Configure Oracle Database Express depending on your operative system: https://www.oracle.com/database/technologies/xe-downloads.html.
2. Download and Configure MySQL depending on your operative system: https://dev.mysql.com/downloads/mysql/
3. Clone the repository

# Clone this repository
$ git clone https://github.com/luisfelipe7/SQL-Review-With-Oracle-MySQL/

4. Go into the repository

# Go into the repository
$ cd SQL-Review-With-Oracle-MySQL

We have simple scripts in charge of creating tables and performing multiple DML and DDL operations. Both of them perform the same things, but they have some differences because of the syntax on each database:

1. SQL-Basics-Review-With-Oracle.sql : Script for Oracle Database Express Edition, designed to work with Oracle.
2. SQL-Basics-Review-With-MySQL.sql : Script for MySQL, designed to work with MySQL.

To execute the Oracle Script just follow these steps:

1. Open the terminal.
2. Locate in the path of the script:

# Move to the path
$ cd pathOfTheScript

3. Then, execute this command to enter the Oracle Database:

# Initialize the Oracle Database
$ sqlplus

4. Enter the user and password.
5. After that execute the script using:

# Executing the script
$ @SQL-Basics-Review-With-Oracle.sql

You are going to see all the errors and outputs.

To execute the MySQL Script just follow these steps:

1. Open MySQL Worbench.
2. Then, open the script using MySQL Workbench: File->Open SQL Script.
3. Using the lightning bolt located on the interface execute the script.

Thanks to UNA (Universidad Nacional de Costa Rica) for teaching everything about SQL and Oracle University for the free course to review the basics of SQL.

GitHub @luisfelipe7  ·