Description
Lab #1: Installations
Learn about hierarchical, networked, and relational databases; introduce you to how to navigate Oracle’s SQL*Plus Command-line Interface (CLI); and how basic SQL queries work.
- Lab
- Description
- Help Section
- Instructions
Lab Description
[30 points] Click the Lab Instructions link to open the instructions inside the current webpage.
The lab requires that you test the elements of the environment and write one integration script. The integration script calls two unit test programs found in the following directory:
/home/student/Data/cit225/oracle/lib1 |
Please perform these tasks after you have downloaded VMware and opened the Fedora virtual instance.
The lab has six parts that are worth five points each. The individual parts are explained in step web pages. The steps are:
- Step 1: Open and learn the basics of using the Fedora Gnome interface.
- Step 2: Navigate to the following directory from the
student
home directory./home/student/Data/cit225/oracle/lib1
- Step 3: Connect to sqlplus as the student user and experiment with the Command-Line Interface (CLI).
- Step 4: Create an
apply_oracle_lab1.sql
script file in the following directory:/home/student/Data/cit225/oracle/lab1
The
apply_oracle_lab1.sql
script should run three scripts from the referenced library directory. You can implement that logic by putting the following into theapply_oracle_lab1.sql
script file:-- Open log file. SPOOL apply_oracle_lab1.txt -- Run instructor provided setup scripts. @@/home/student/Data/cit225/oracle/lib1/utility/cleanup_oracle.sql @@/home/student/Data/cit225/oracle/lib1/create/create_oracle_store2.sql -- Close log file. SPOOL OFF
- Step 5: Connect to SQL Developer and view the contents of the tables you created in Step 4.
- Step 6: Connect to APEX Web Interface and query the contents of the tables you created in Step 5.