chapter13 - SQL> SQL> Oracle SQL chapter 13 SQL> BMIS441\/MBUS699 Business Database Systems SQL> Jason Chen SQL> Row 0 SQL> students are required to work

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

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

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
Image of page 1
in the view
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '10
  • HARLAL

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture