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