Downloading and Saving the SQL Script

The first thing that you have to do is to download and save the script that will populate the database. Here is a copy of the script. You can also go to the authors' download site for this and other scripts. Make sure that you save the script as SG.sql. It should have only .sql extension and not .txt.

Running the Script

Open SQL Developer and login to the CS Oracle server. If you have saved your settings you could just select the connection name and it will connect you to our Oracle server.

Here are the steps on running the script SG.sql:

1. File -> Open -> SG.sql
2. On the right pull down menu select your Connection name.
3. Hover your mouse on the second button on the top right window. It should say Run Script. Press that button. Once that completes you will see a Results Window with the message:
   Creation and population of database has been completed.
   
4. Hover your mouse on the third button on the top right window. It should have a check mark on it. Click it to commit your changes.
5. View -> refresh
6. Click on your connection tab on the left and click on Tables. You should see all the tables that have been loaded.