chapter13 - SQL> SQL> Oracle SQL chapter 13 SQL>...

SQL>
SQL> -- Oracle SQL, chapter 13
SQL> -- BMIS441/MBUS699 Business Database Systems
SQL> -- Jason Chen
SQL> -- Row: 0
SQL> -- students are required to work from #1 to #5 and #9, #10
SQL>
SQL> DROP VIEW contact;
View dropped.
SQL> DROP VIEW homework13;
View dropped.
SQL> DROP VIEW reorderinfo;
View dropped.
SQL>
SQL>
SQL> --1.
SQL> CREATE VIEW contact
2 AS SELECT contact, phone
3 FROM publisher;
View created.
SQL>
SQL> -- 2.
SQL> CREATE OR REPLACE VIEW contact
2 AS SELECT contact, phone
3 FROM publisher
4 WITH READ ONLY;
View created.
SQL>
SQL> --3.
SQL> CREATE FORCE VIEW homework13
2 AS SELECT col1, col2 FROM firstattempt;
Warning: View created with compilation errors.
SQL>
SQL> --4.
SQL> DESC homework13;
ERROR:
ORA-24372: invalid object for describe
SQL>
SQL>
SQL> --5.
SQL>
SQL> CREATE VIEW reorderinfo
2 AS SELECT isbn, title, contact, phone
3 FROM books JOIN publisher USING(pubid);
View created.
SQL>
SQL> --6. (see p.419 for Key-PRESERVED TABLE)
SQL> --Note: will not execute since the primary key for PUBLISHER table is not

in the view