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
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
