Devon Sanderson
CTS2440
ORACLE/SQL
1.
I used:
CREATE VIEW contact
AS SELECT contact, phone
FROM publisher;
And got
View created.
2.
I used:
CREATE OR REPLACE VIEW contact
AS SELECT contact, phone
FROM publisher
WITH READ ONLY;
And got:
View created.
3.
I used:
CREATE FORCE VIEW homework13
AS
SELECT Col1, Col2 FROM firstattempt;
And got:
View created
4.
I used:
DESC homework13;
5.
CREATE VIEW reorderinfo
AS SELECT isbn, title, contact, phone
FROM books JOIN publisher USING (pubid);
6.
I used:
UPDATE reorderinfo
SET contact = ‘YOUR NAME’
WHERE contact = ‘RENEE SMITH’;
And got the error:
SET contact = 'YOUR NAME'
*
ERROR at line 2:
You've reached the end of your free preview.
Want to read both pages?
- Fall '15
- Instructor:MANNION,STEVEN,C
- Foreign key, Articles with example SQL code, FORCE VIEW homework13, UPDATE reorderinfo
