- Look at the course Schedule
to understand the tasks and assignment of the week.
- If you have any questions regarding the course, email me using the email within D2L.
- If you have any technical difficulty or problems related to this
course, post it on D2L Discussion Board. Week 2: Problem and Solutions.
You will receive help from the entire class.
- Look at the course web site. I will constantly update the notes
and resources sections based upon the needs of students.
- Please consult Course Policy when formulating your response to discussion
question of the week. Grading on discussion will be conducted according
to the policy, including required humor.
- Plan to read and complete all exercises through this chapter on
the course web site for this week. This is the major portion for
mid term term test.
- You will need to use the scripts provided on the course web site.
You may download it at the Resources page of this course, or at the Required Reading column in Schedule.
- On earlier versions, your password for SYSTEM user should be MANAGER if you have not
changed your settings since installation. Starting in Oracle10g, you have to enter your password. Your password will be whatever you entered during installation.
- If you have any problem running the supplied script, I will check the following as the first attempt: You will need to use Notepad to open
the file (chap04.sql), edit the lines "CONNECT system/&system_password."
Add your database name (oracle) and change it to "CONNECT system/&system_password@oracle."
Save the file (chap04.sql). Then, you may proceed as instructed from
the text on the web site. Please note that there are two CONNECT
lines to edit in the file. Please note that your database name may not be "oracle." In this case, use whatever you defined as SID during installation.
- The supplemental reading for this chapter provide you with many
efficient tips. Particularly, please pay attention on the SQL Script
part since you are required to submit a SQL script for Project
II of the week.
- Study the script file chap04.sql will give you a lot of details
on SQL programming. Your project II submission is similar but a
lot simpler than chap04.sql. However, they function the same way
in terms of execution or application.
- Please use text editor such as Notepad or WordPad to edit your SQL script. Word processing software such as Microsoft Word will add too much junk to your code, which will cause problems.
|
