CS669_Lab1SubmissionTemplateforBothVersions

CS669_Lab1SubmissionTemplateforBothVersions - MET CS 669...

Info icon This preview shows pages 1–12. Sign up to view the full content.

View Full Document Right Arrow Icon
MET CS 669 Database Design and Implementation for Business Lab 1 Submission Name : Shabista Rizvi Date: 05/18/2015 SECTION ONE 2 CREATE TABLE command Page 1 of 29 Copyright 2012-2015 Boston University. All Rights Reserved.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4. INSERT INTO command 6. SELECT command Page 2 of 29
Image of page 2
8. UPDATE command 10. SELECT command Page 3 of 29
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
12. DELETE command 14. SELECT command Page 4 of 29
Image of page 4
16. DROP command 18. SELECT command Page 5 of 29
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Page 6 of 29
Image of page 6
SECTION TWO 19. Table creation 20. Row insertion Page 7 of 29
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
21. Row listing 22. Row update Page 8 of 29
Image of page 8
23. Row listing 24. Row removal Page 9 of 29
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
25. Row listing 26. Table drop Page 10 of 29
Image of page 10
27. Row listing attempt 28. Diagnosis explanation This error message means that Oracle cannot find the table or view specified in the select query. Oracle error message specifies “table or view” because the object referenced by this select could be a table or a view. The error message does not give the name of object which is missing but rather provides line number where the problem occurred. We can see, error message complains about line 2. If we look at the query, we can see “Medication” table is being referenced at line 2. This shows that “Medication” table is missing and that is the source of the error. The “Medication” table is missing because we dropped it in previous step. There could be some other scenarios where this error can occur. For example, if the table or view being referenced exists under a different schema and that schema prefix is not used. When this error occurs, it is helpful to view data dictionary tables, such as “all_tables” or “all_objects” to find out if the object is really missing or if there is a typo or the object exist under different schema on same database.
Image of page 11

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 12
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern