How to Set Up for Oracle PL/SQL Training

  • google plus

In Brief...

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.

Instructions

Operating System Requirements

You can use any modern operating system in this class. If you have any doubts about your operating system, please email support@webucator.com.

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, which you can download here. Be sure to download the correct setup file for your operating system.

You will need to register for a free account to gain access to the download.

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 sqldeveloper.zip 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.

Download and Install Class Files

  1. Download the class files.
  2. After downloading the class files, create a directory on your hard drive named Webucator that can be found easily.
    1. On Windows it is recommended the new folder have a path of C:\Webucator.
    2. On Mac OS X a good location for the new folder may be in your Documents directory.
  3. Extract the files to the folder you just created.

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.

Related Training

Author: Nat Dunn

Nat Dunn founded Webucator in 2003 to combine his passion for web development with his business expertise and to help companies benefit from both.

Discuss