Database Tutorial

Course Tutorial Site

Site Admin

Lab #1 : Oracle SQL*Plus

with 2 comments

Lab #1: Oracle Assignment

After you copy and start the Fedora image, you need to log into the instance as the student user. Login as the student user, as shown in the following screen shots:

  1. [2 points] Open and learn the basics of using the Fedora Gnome interface:

After you launch the Terminal, you can do the following steps as the student user. If you expand the Instruction Details, you can see the individual subtasks:

  1. [2 points] Navigate to the lab1 directory from the student home directory:

  1. [2 points] Connect to sqlplus as the student user:

  1. [2 points] Run the apply_oracle_lab1.sql script, which runs three scripts: (a) the cleanup_oracle.sql script, (b) the create_oracle_store.sql script, and (c) the seed_oracle_store.sql script.

  1. [2 points] Query the data dictionary to find the tables created by the create_oracle_store.sql script.:

Written by michaelmclaughlin

December 29th, 2009 at 4:39 pm

Posted in

2 Responses to 'Lab #1 : Oracle SQL*Plus'

Subscribe to comments with RSS or TrackBack to 'Lab #1 : Oracle SQL*Plus'.

  1. Section 4

    “You call the file in sqlplus like this:

    SQL> @apply_oracle_lab1.SQL”

    .SQL shouldn’t be on there, especially in caps

    Braden Bullock

    18 Sep 15 at 1:12 pm

  2. Braden, I fixed it. Thanks.

    michaelmclaughlin

    24 Sep 15 at 11:17 pm

Leave a Reply