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......
Join Now or Login to view the rest of this paper.
Approximate Word Count: 720
Approximate Pages: 3 (260 words per double-spaced page) |