OPPapers.com

35567789

CPRG 250 – TESTING INSTALLATION OF ORACLE Download the script file, CreateAndLoadHospital.sql from WebCT (Course Resources). Log into Oracle Express Edition. Click on the SQL icon. Click on SQL Scripts. Click on Upload. Browse to find the script that you downloaded from WebCTand select it. Click on Upload. Click on the script icon. This should take you to a window where the script file is displayed. Click on Run. Confirm that you want to Run the script. Click on Details in the View pulldown list. Click on the View Results icon. Examine the results to see that each of the tables has been created and that data has been inserted into each of the tables. Your output should look something like the output shown below. DROP TABLE insure
ORA-00942: table or view does not exist {draw:rect} DROP TABLE insurance
ORA-00942: table or view does not exist {draw:rect} DROP TABLE patient
ORA-00942: table or view does not exist {draw:rect} DROP TABLE doctor
ORA-00942: table or view does not exist {draw:rect} CREATE TABLE doctor ( )
Table created. 0.21 seconds {draw:rect} CREATE TABLE patient ( )
Table created. 0.05 seconds {draw:rect} CREATE TABLE insurance ( )
Table created. 0.01 seconds {draw:rect} CREATE TABLE insure ( ` CONSTRAINT insure_pk PRIMARY KEY (PATIENT$id, INSURANCE$company) ` )
Table created. 0.04 seconds {draw:rect} INSERT INTO doctor ` (id, fname, lname, phone, beeper) ` VALUES ('00001', 'Perry', 'Cox', '4035551111', '4035551212')
1 row(s) inserted. 0.00 seconds {draw:rect} INSERT INTO doctor ` (id, fname, lname, phone, beeper) ` VALUES ('00002', 'Eliot', 'Reid', '4035552222', '4035552323')
1 row(s) inserted. 0.00 seconds {draw:rect} INSERT INTO doctor ` (id, fname, lname, phone, beeper) ` VALUES ('00003', 'JD', 'Dorian', '4035553333', '4035553434')
1 row(s) inserted. 0.00 seconds {draw:rect} INSERT INTO doctor ` (id, fname,...