Message from
Name: TA
Email:
Time/Date:12:43:31 / 12-3-102,
Posted Message: Dear CS1555, As Dr. Chang and I have the different grade file, you may could not receive the update grade vector for the quiz/exercise. As the final exams has been graded, Dr. Chang would send you final update one. You could double check it at that time. BTW, I will proctor the final this Thursday. Please bring all the late excercises by that class, if you still want to submit. That is final deadline, no submission is allowed after that. If the Question3 on Quiz2 was overcharged to you, you should bring that with you that day. Good Luck to your finals. TA


CS1565 Message from
Name: Jim
Email:
Time/Date:18:31:21 / 11-19-102,
Posted Message: Did anyone have any luck getting Webbase to connect to the Oracle Database? Getting errors getting the two to connect. Any help would be great.


Message from
Name:
Email:
Time/Date:17:23:17 / 11-19-102,
Posted Message: Dear Class 1555: About Quiz2, I may overcharge question #3 0.5/1 point as I understood your relations to be the dependence graphs. Come to my office hour tomorrow, I could change it back for you. Thanks. TA


CS1565 Message from
Name: Daniel
Email:
Time/Date:11:42:17 / 11-18-102,
Posted Message: When using WebBase, after writing your .htf file, how do you load the file to the web server?? Are there any commands you'll have to input to the webbase program Your help will be highly appreciated.


Message from
Name: TA
Email:
Time/Date:12:59:4 / 11-13-102,
Posted Message: Dear Class CS1555: Nov 13 Wendesday's office hour (1-3PM) will be canceled. If you have any question, please send me email to make an appointment with me to catch up. TA


Message from
Name: TA
Email:
Time/Date:9:54:34 / 10-30-102,
Posted Message: Dear Classs 1555, Tuesday evening one student took my textbook from my office by mistake and forgot his pen here. Please return the book and take your pen during my office hour. Thanks. TA


Message from
Name: TA
Email:
Time/Date:11:56:44 / 10-23-102,
Posted Message: Dear CS1555 Class: If you want to use Java, VC++, ASP or any other tools to design your Ex5, but you could only run it on your own machine. You just need to turn some hardcopy to me and demo that to me during my office hour. TA


Message from
Name:
Email:
Time/Date:11:55:50 / 10-23-102,
Posted Message: Dear CS1555 Class: If you want to use Java, VC++, ASP or any other tools to design your Ex5, but you could only run it on your own machine. You just need to turn some hardcopy to me and demo that to me during my office hour.


Message from
Name: TA
Email:
Time/Date:11:41:32 / 10-7-102,
Posted Message: Dear CS1555 Class, Due to my scheduled regular meeting with the instructor of my another TA's work, my office hour is changed to be: Monday 11:30-2:30 Wednesday 11:30-12:30 and 1:00-3:00 Valid since Oct. 9th. Thanks. Welcome to use it.


CS1565 Message from
Name: Xiaoting Tang
Email: xit5@pitt.edu
Time/Date:12:42:33 / 10-4-102,
Posted Message: 1994 Toyota Camry for sale, newly inspected (Sep 2003),116K (mostly highway mileage), auto, AC, cruise control, all power, excellent body, runs great! New timing belt, starter, battery… Moving, must sell. Ask for $4900, obo. Call tang @ 412-889-1237, or email xit5@pitt.edu


Message from
Name: Xiaoting Tang
Email: xit5@pitt.edu
Time/Date:12:42:33 / 10-4-102,
Posted Message: 1994 Toyota Camry for sale, newly inspected (Sep 2003),116K (mostly highway mileage), auto, AC, cruise control, all power, excellent body, runs great! New timing belt, starter, battery… Moving, must sell. Ask for $4900, obo. Call tang @ 412-889-1237, or email xit5@pitt.edu


CS1565 Message from
Name: Miao
Email:
Time/Date:13:0:46 / 10-3-102,
Posted Message: Does anyone know exactly what we're supposed to do for number 2? Do we do either a flowchart or the pseudo code or both?


CS1565 Message from
Name: Szpanka
Email:
Time/Date:19:13:16 / 9-27-102,
Posted Message: This is for the guy who asked about documentation on Oracle's SQL functions:


CS1565 Message from
Name: Szpanka
Email:
Time/Date:10:48:57 / 9-27-102,
Posted Message: This is for the guy who asked about documentation on Oracle's SQL functions:


CS1565 Message from
Name: Davor
Email: dabst68@pitt.edu
Time/Date:10:43:56 / 9-24-102,
Posted Message: If you have trouble with DATE business then use the TO_DATE function of SQL. example: insert into temp_table (date_field) values (to_date('11/2/90','MM-DD-YY')); For the select part you have to use TO_CHAR function. example: select to_char(date_field,'MM-DD-YY') from some_table; If date in the cell is 12-Sep-2002 it wil be displayed as 9-12-02.


Message from
Name: Emil
Email: eim2@pitt.edu
Time/Date:0:37:58 / 9-24-102,
Posted Message: The date datatype documentation has go to be the worst ever. Anyway if anyone has had problem with the date format here is what worked for me. The book says to use the YYYY/MM/DD format. That is completely wrong for Oracle. Oracle's default (which I don't know how to change is) DD/MMM/YY . Notice the 3 Ms. The month is entered as 3 characters not a number. i.e. June is Jun, January is Jan etc. For example April 5th 1983 would be: 05/Apr/83 I hope this helps some people.


CS1565 Message from
Name: Steve
Email: set19@pitt.edu
Time/Date:14:10:34 / 9-23-102,
Posted Message: Moving past Oracle installation and to the actual assignment.... I was wondering if anyone completed the last Query sucessfully, and if so, how did you implement it - i've been considering storing the Modules as two seperate entities, one for the letter and one for the number, but this just seems like a long approach.


CS1565 Message from
Name: Lidiya
Email: libst18@pitt.edu
Time/Date:13:20:33 / 9-23-102,
Posted Message: * Steve, I did install the personal edition of Oracle8i. I did custom installation and the Navigator checkbox is way at the bottom of the tree(I do not remember the exact location). * The websites I posted are something that I found when I did a google search. Which one can't you access? I will post it here.


CS1565 Message from
Name: Matt Creegan
Email:
Time/Date:10:51:39 / 9-23-102,
Posted Message: I had a previous installation of Oracle 9 (not the current release, but the previos one - 9.0.1) running before taking this course, but Navigator wasn't installed along with it. I figured it must be one of the custome elements, so I began a new installation on another (similar) machine to see if Navigator would be useful. Only problem is I can't find Naviator anywhere in the installation options! Anyone else had luck? From what was explain in class about Navigator, I don't think it's the least bit necessary to do our projects; it just seems strange that so many people aren't getting it to install.


CS1565 Message from
Name: Steve
Email: set19@pitt.edu
Time/Date:1:19:19 / 9-23-102,
Posted Message: Fernando - I got 8i on XP no problem, but i have a P3, just to be safe I put it in C:\Oracle, instead of in Program Files, this may have made the difference. Lidiya - Your webpage is forbidden, so noone can read the help you put there. I am curious though, I have most of Oracle installed, and nowhere, even in the Custom install do I see Navigator. Is it under the personal edition part? can you tell me exactly where it appears in the directory tree? Also.... I'm still stuck on this DATE business, all docs I've read within oracel, and all over the web, and the book, show DATEs in YYYY-MM-DD format, but i won't work for me in SQL+???


CS1565 Message from
Name: Fernando
Email: fai1@pitt.edu
Time/Date:23:41:2 / 9-22-102,
Posted Message: Has anyone been able to install ANY version of Oracle on Windows XP running on a Pentinum 4 processor? If you have, what version are you using and what modifications were needed to enable the installation? Thanks!


CS1565 Message from
Name: Lidiya
Email: libst18@cs.pitt.edu
Time/Date:20:6:23 / 9-22-102,
Posted Message: Here are some things I learned the hard way: * You have to go through "Custom" installation and select to install the Navigator. It does not come with "Typical" installation. *To set up the listener & get started with Oracle, use the directions on this website. If your installation went well, everything should work well. http://www.cs.pitt.edu/~lilyzhao/CS1555.htm * I have a similar problem with the requesting of the password(without a user name). Here is a post that I found that explains the problem. In my case I am completely missing the crucial initSID.ora file. http://www.orafaq.com/msgboard/windows/messages/1368.htm http://www.orafaq.com/msgboard/windows/messages/226.htm Good Luck to all!


CS1565 Message from
Name: Steve
Email: set19@pitt.edu
Time/Date:4:9:2 / 9-22-102,
Posted Message: Is anyone else having trouble with Dates? I've created my table using the DATE type for the completion date, but when i try to insert data int that field (in the form YYYY-MM-DD as described in the book) i get the error message 'inconsistant data types'? any help is appreciated. thanx, steve


CS1565 Message from
Name: Daniel
Email: dmrst51@pitt.edu
Time/Date:17:58:11 / 9-20-102,
Posted Message: I have created a table using sqlplus and atext editor, how do I view the table I have created? Thank in advance for you help.


CS1565 Message from
Name: jeff h
Email: jth16@hotmail.com
Time/Date:16:14:2 / 9-19-102,
Posted Message: i am having trouble starting my listener. i do not have and can not find the exe called lsnrctl. If anybody can help me find this utility or how to get around it, it would be great.... i am running the schools 8i on ME.... and i believe i need this so that i can login and connect to the database from sqlpl, correct?


CS1565 Message from
Name: Davor Brekalo
Email: dabst68@pitt.edu
Time/Date:11:18:46 / 9-19-102,
Posted Message: Here is a link that can tell you more about the Oracle and its commands "http://storacle.princeton.edu:9001/oracle8-doc/server.805/a58225/toc.htm" If this supports HTML than this is the hyper link


Message from Prof. Chang: Some of you may have some trouble with the second assignment. The due date of Exercise 2 is next Tuesdsay, Sept. 24, but I reduce the late penalty. After the due date, please submit the assignment directly to Mr. Huang. His mailbox is in the mail room on the fifth floor. Leave the assignment in his mail box. For this assignment, there will be only one point penalty if you can submit it by next Thursday, Sept. 26. After next Thursday, late submissions will not be accepted. If you have any problems, please go to see the TA during his office hours. When you first install and experiment with a new system it is always frustrating. But you will overcome the difficulties after a while and enjoy the satisfaction of success. Here is a message from the TA.....

Hi, As some of you may have trouble installing navigator with Oracle 8i or 9, please forget about it temporarily. You are asked to use "SQL*PlUS" to do the homework. We learned "navigator" just for the class and would not use it right now. As you launch the "SQL*PLUS", you could input user as "scott", password as "tiger". Then run the already edited sql file with command "start ~path/filename.sql". Please read it the headout carefully and read the first half part of Chapter 8 before you really start to write the sql script. TA

Class Handout:
Hints on Excercise 2 for CS1550(Fall/02)





##############################################################



-- Create Table



CREATE TABLE STUDENT (--Need to Modify--);



-- Insert Table



INSERT INTO STUDENT () VALUES (--Need to Modify--);



-- Question1



-- Question2



-- Question3



-- Question4





-- Drop Table



DROP TABLE STUDENT;



##############################################################



Note:



Don't use Navigator do this excercise, but use some editor such as NOTEPAD to edit all of the stuff in one file with extension ".sql".

When using NOTEPAD to edit .sql file, make sure its extension is .sql NOT .txt (in Save as type, choose All Files).



The above schema is strong recommanded to follow, especially " DROP TABLE STUDENT; " is required.



When I grade, I just need to input command: " start A:/yourfile.sql " in SQL Plus to get the correct result;



DATE input format could use "10-NOV-90" and Date Field(colum) name should be something like "COMPLETE_DATA" not "DATE", which is a keyword.

CS1565 Message from
Name: Aaron
Email:
Time/Date:10:49:59 / 9-19-102,
Posted Message: I don't know if anyelse is having this problem, but I downloaded oracle 9i for windows 98. it installs on windows ME with no problem. But when you go to run ANY application it asks for a PASSWORD (not username and password, JUST password). after 3 attempts it shuts everything oracle down. Does anyone know what this password is? I have tried looking through the documentation from oracle but haven't found anything.


CS1565 Message from
Name: jeff h
Email: jth16@hotmail.com
Time/Date:15:22:1 / 9-18-102,
Posted Message: i to am having trouble getting the navagator to install, i'm trying to get some help.... if i do , i'll let you know, and i hope likewise...... but other then that it's good to see some people in the same boat;}


CS1565 Message from
Name: Emil
Email:
Time/Date:1:43:57 / 9-18-102,
Posted Message: Has anyone been able to figure out how to get the oracle 8 Navigator to install yet?


CS1565 Message from
Name: Lidiya
Email: libst18@pitt.edu
Time/Date:17:31:10 / 9-17-102,
Posted Message: Hey, here is a fix that worked for me to install Oracle8i on XP. Follow the steps: 1 - Copy the content of your Oracle CD into hard disk in your machine. For example Copy from oracle8i CD into D:\Oracle\ ... 2 - Search the file Symcjit.dll on the D drive (where you have copied Oracle8i. You can found it in: - For Oracle8i 1.7: D:\Oracle\stage\Components\oracle.swd.jre\1.1.7.30\1 \DataFiles\Expanded\jre\win32\bin\symcjit.dll - For Oracle8i 1.6: D:\Oracle\stage\Components\oracle.swd.jre\1.1.7.24\1 \DataFiles\Expanded\jre\win32\bin\symcjit.dll 3 - Rename this file (Example): symcjit_back.dll 4 - Execute the Oracle setup.exe from D:\Oracle\setup.exe


CS1565 Message from
Name: Aaron
Email:
Time/Date:16:9:41 / 9-17-102,
Posted Message: Just in case nobody is aware of this but you can download Oracle 8i and 9i for free off of the Oracle site.


CS1565 Message from
Name: Winston
Email: wec18@pitt.edu
Time/Date:13:8:26 / 9-12-102,
Posted Message: How is everyone's experience with Oracle so far. I'm having a problem running the listener and can find no help. There is no lsnrctl.exe on my system and I see nothing so far referring to running the listener. I'm running Windows ME and was told to use Oracle 8i for Windows NT/2000. The configuration of the listener and the local net service name seems to have gone OK. I have screen shots of what I have done if anyone thinks they can help me.


CS1565 Message from
Name: Lidiya
Email: libst18@pitt.edu
Time/Date:23:19:57 / 9-9-102,
Posted Message: Correct me if I am wrong, but you need to create a relationship type b/w student entity and grade report entity that corresponds to their interdependence. Look @ the notes from last class. I hope this helps.


CS1565 Message from
Name: Daniel
Email: dane_flav@hotmail.com
Time/Date:11:50:0 / 9-9-102,
Posted Message: Exercise 1 Help! Hi Part (e) of the assignment says that "A grade report has student...." I think this implies that grade report is an entity and student is an attribute. But then in part (a) we have student as an attribute. Is it possible to have an attribute to an entity be an entity or am I mistaken in part (a) the entity is university not student? Your help will be appreciated.


Message from
Name: Prof. Chang
Email:
Time/Date:20:28:32 / 9-4-102,
Posted Message: The first exercise will be due next Tuesday, Sept 10.


Message from
Name: Prof. Chang
Email:
Time/Date:18:18:0 / 9-4-102,
Posted Message: Dear CS1555/1565 Students: If you have regiestered online, you will receive this welcome message. The audio file for the third lecture is online. You can listen to the lecture using RealPlayer. Go to my lecture notes to discover the link. Prof. Chang