1220 Chapter 13 Lab.docx - Lonnell Higgins Jr Mr Chen October 3 y CIST 1220 Lab 1 2 3 Create a view that lists the name and phone number of the contact

1220 Chapter 13 Lab.docx - Lonnell Higgins Jr Mr Chen...

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

Lonnell Higgins Jr Mr. Chen October 3, y CIST 1220 Lab 1.Create a view that lists the name and phone number of the contact person at each publisher. Dont include the publishers ID in the view. Name the view CONTACT. CREATE VIEW CONTACT AS SELECT CONTACT, PHONE FROM PUBLISHER; 2. Change the CONTACT view so that no users can accidentally perform DML operations on the view. CREATE OR REPLACE VIEW CONTACT AS SELECT CONTACT, PHONE FROM PUBLISHER WITH READ ONLY 3.Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '20
  • Foreign key

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture