TEC 5323 Advanced Database Technology


Important Tips

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.

 

School of Technology
College of Business & Applied Sciences
Eastern Illinois University