TU B mai
Hand-on assignment
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
You've reached the end of your free preview.
Want to read the whole page?
- Fall '18
- LarryA.Ray
- Foreign key, Prime number, Articles with example SQL code, RENEE SMITH, 9876543210
