How to Set Up for Advanced Oracle SQL Queries and / or Oracle PL/SQL Training

Before you attempt the setup, please uninstall any instance of MySQL before continuing. Students in our Oracle PL/SQL Training class can use Oracle 10g, 11g, or 12c and SQL Developer. Here are the instructions for setting up your computer.

Operating System Requirements

PC: Windows 10

Version of Oracle Database

You need to have full administrative access to Oracle 10g, 11g, or 12c.

If you do not yet have Oracle installed, you can use Oracle 11g Express Edition. To do so:

  1. Download it here. Be sure to download the correct setup file for your operating system.
  2. You will need to register for a free account to gain access to the download.
  3. Run through the installer accepting all the defaults. Set your password to "system" (all lowercase without the quotes).

Very Important

  • This class requires the use of the Oracle supplied HR demo schema, with the permissions and objects in the state in which Oracle created them. The HR schema is created by default during an install but is not always unlocked. Please unlock the schema, assigning a password. Please make sure the student has the password.
  • If you will be using a work laptop at home, then install Oracle at home. If your IT department is installing it at work, make sure they disconnect from both the internet and the intranet before launching the install. The safest way to do this is to remove the ethernet connection from your laptop and turn off your wireless connection.
  • This class requires the use of serveroutput and the Oracle supplied package dbms_output. SQL Developer needs to have serveroutput enabled. By default everyone has permission to use this package and by default SQL Developer may enable serveroutput. Please verify the permission and enablement. (This will be covered in class)

Oracle SQL Developer

  1. Download the version of Oracle SQL Developer that corresponds to your operating system.
    1. If you are on Windows 64-bit be sure to choose the "Windows 64-bit with JDK 8 included" option.
  2. Create a new sqldeveloper folder in C:\Oracle\ and extract the archive to the new sqldeveloper folder. This will place a new sqldeveloper.exe executable in the folder.
  3. Double-click on sqldeveloper.exe executable to start SQL Developer.

Unlocking the HR Account

  1. In SQL Developer, log in using this connection
    1. Connection name: system
    2. Username: system
    3. Password: system (This should be the password you created when you installed Oracle)
  2. Open the HR_Unlock_Account.sql file from your class files.
  3. Click on the second green play button (F5) to execute the SQL query.
  4. To continue setup, click on the green + under the Connections tab, and add the criteria below:
    1. Connection Name: hr
    2. Username: hr
    3. Password: hr
    4. Click Connect. A worksheet should open up on a tab that's labeled "hr".
  5. Now that you're connected to HR, you're ready to test.
    1. Enter the following query in the worksheet: select * from regions;
    2. Click the "green arrow" to execute your code.
    3. If 4 rows of 2 columns are returns by the query then you are all set.