lab13.docx - Lab 13 Professor Chen Renate Hamrick Lab 13 1 create view contact as select contact phone from publisher 2 create or replace view contact

lab13.docx - Lab 13 Professor Chen Renate Hamrick Lab 13 1...

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

Lab 13Professor ChenRenate HamrickOctober 25, 2018
Background image
Lab 131.create view contactas select contact, phonefrom publisher;2.create or replace view contactas select contact, phoneFrom publisherwith read only;3.create force view homework13as select acol1, col2 from firstattempt;4.desc homework13;5.create view reorderinfoAs select isbn, title, contact, phoneFrom books join publisher using (pubid);6.update reorderinfoset contact = 'YOUR NAME'
Background image

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture