Chapter 13 Oracle Book Questions - Devon Sanderson CTS2440 ORACLE\/SQL 1 I used CREATE VIEW contact AS SELECT contact phone FROM publisher And got View

Chapter 13 Oracle Book Questions - Devon Sanderson CTS2440...

This preview shows page 1 - 2 out of 2 pages.

Devon Sanderson CTS2440 ORACLE/SQL 1. I used: CREATE VIEW contact AS SELECT contact, phone FROM publisher; And got View created. 2. I used: CREATE OR REPLACE VIEW contact AS SELECT contact, phone FROM publisher WITH READ ONLY; And got: View created. 3. I used: CREATE FORCE VIEW homework13 AS SELECT Col1, Col2 FROM firstattempt; And got: View created 4. I used: DESC homework13; 5. CREATE VIEW reorderinfo AS SELECT isbn, title, contact, phone FROM books JOIN publisher USING (pubid); 6. I used: UPDATE reorderinfo SET contact = ‘YOUR NAME’ WHERE contact = ‘RENEE SMITH’; And got the error: SET contact = 'YOUR NAME' *
Image of page 1
ERROR at line 2:
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '15
  • Instructor:MANNION,STEVEN,C
  • Foreign key, Articles with example SQL code, FORCE VIEW homework13, UPDATE reorderinfo

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture