- 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.
- From this chapter on, you can login into your database on your
own computer and complete all exercises shown in the book. If you
have not changed it during and after installation, you can use Username:
scott and Password: tiger and Host String: oracle. (For personal
edition, you may have to leave the Host String blank.).
- 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 for Week 5.
- 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 do not like any default password (such as SCOTT/tiger, SYSTEM/manager, you may use the same procedure to change them using Oracle Enterprise Manager (EM).
- 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 the Project
III of the week.
- Study the script file chap04.sql will give you a lot of details
on SQL programming. Your project III 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.
|
