Chapter 13 - 1 CREATE VIEW contact AS SELECT contact phone FROM publisher 2 CREATE OR REPLACE VIEW contact AS SELECT contact phone FROM publisher WITH

Chapter 13 - 1 CREATE VIEW contact AS SELECT contact phone...

This preview shows page 1 out of 1 page.

1. CREATE VIEW contact AS SELECT contact, phone FROM publisher; 2. CREATE OR REPLACE VIEW contact AS SELECT contact, phone FROM publisher WITH READ ONLY; 3. CREATE FORCE VIEW homework13 AS SELECT Col1, Col2 FROM firstattempt; 4. DESC homework13; 5. CREATE VIEW reorderinfo AS SELECT isbn, title, contact, phone FROM books JOIN publisher USING (pubid); 6. UPDATE reorderinfo SET contact = YOUR NAME WHERE contact = RENEE SMITH ; Error Received: SET contact = 'YOUR NAME' * ERROR at line 2: ORA-01779: cannot
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Fall '15
  • Instructor:MANNION,STEVEN,C
  • Foreign key, CREATE VIEW contact, FORCE VIEW homework13, non key-preserved table, SELECT contact

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture