C. Getting Started with Oracle
The following describes the procedure to install the free version of Oracle on a computer running Windows. Note that the procedure may vary, depending on what is already installed on your PC. There is just one step for the install:
Install Oracle Database Express Edition.
Oracle SQL Developer
This installation of Oracle Database Express Edition will create a single database on your PC. Oracle SQL Developer is an application that allows you to execute SQL commands against that database. At the time of the writing, Oracle Database Express Edition is at version 18c, and Oracle SQL Developer is at version 20.4.
Installing Oracle Database Express Edition
This procedure will install the Oracle Database Express Edition. The steps for installing are as follows:
1. Go to oracle.com/database/technologies/appdev/xe.html.
2. Select DOWNLOAD ORACLE DATABASE XE.
3. Select the Express Edition for Windows
4. Accept the license agreement, then select the download.
5. Create an Oracle account or sign in with an existing account.
6. When the download completes, open the ZIP file.
7. Double-click the SETUP.EXE file to start the installation.
8. When asked if you want this app to make changes to your device, select YES..
9. On the Welcome pane of the install wizard, click NEXT.
10. On the License Agreement pane, accept the terms, and then click NEXT.
11. On the Choose Destination Location pane, accept the default location and click NEXT.
12. On the Specify Database Passwords pane, enter a password, and then click NEXT.
13. On the Summary pane, click INSTALL.
14. When the install completes, click FINISH.
After these steps have been completed, you will see Oracle software installed under the Oracle Ora18DBHome directory in the Start Menu.
Installing Oracle SQL Developer
This procedure will install the Oracle SQL Developer application. The steps for installing are as follows:
1. Go to oracle.com/database/technologies/appdev/sqldeveloper-landing.html.
2. Select SQL Developer.
3. Select the appropriate edition, accept licensing terms, and start the download.
4. Create an Oracle account or sign in with an existing account.
5. When the download completes, extract all files from the ZIP file.
6. Double-click the SQLDEVELOPER.EXE file to start the installation.
7. Upon completion, the Oracle SQL Developer application will automatically open.
8. In the Connections pane, select the XE database, then enter username SYSTEM and the password you previously specified.
9. After the above has completed, you can return to the application by executing the same SQLDEVELOPER.EXE file. Alternatively, you can pin the file to the Start Menu or Task Bar by right-clicking the file and selecting either option.
Using Oracle SQL Developer
To gain access to the Oracle database, execute the SQLDEVELOPER.EXE file. As noted above, you might want to pin this file to the Start Menu or Task Bar. Connect to the XE database with username SYSTEM and the password you previously specified. Experience Oracle users can create a TNS file to store the connection information on your PC so it doesn’t need to be entered every time the application is used. After the connection to the database is established, you can then enter any desired SQL command from the provided query window.
Installing Oracle Database Express Edition
Installing Oracle SQL Developer