Ch3AQueries - - File name: Ch3AQueries.sql - by J. Chen...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
-- File name: Ch3AQueries.sql -- by J. Chen 9/1/08 - -- chapter 3, Figure 3-1; p.87 START c:\OraData\Chapter3A\emptynorthwoods.sql; S -- chapter 3, Figure 3-2; p.89 INSERT INTO faculty (F_FIRST, F_LAST, F_ID) VALUES (1, 'Teresa','Marx'); V -- chapter 3, Figure 3-3; p.90 INSERT INTO location VALUES (9, 'BUS','424',1); V -- chapter 3, p.90 INSERT INTO faculty (F_ID, F_LAST, F_FIRST, F_MI, LOC_ID) VALUES (1, 'Marx', 'Teresa', 'J', 9); V -- chapter 3, Figure 3-4; p.95 INSERT INTO student VALUES ('JO100', 'Jones', 'Tammy', 'R', '1817 Eagleridge Circle', 'Tallahassee', 'FL', '32811', '7155559876', 'SR', TO_DATE('07/14/1985', 'MM/DD/YYYY'), '8891', 1, TO_YMINTERVAL('3-2')); 1 -- chapter 3; p.96 INSERT INTO faculty (F_ID, F_LAST, F_FIRST, F_IMAGE) VALUES (2, 'Zhulin', 'Mark', EMPTY_BLOB()); V COMMIT; C -- chapter 3, Figure 3-5; p.98 INSERT INTO course VALUES ('CGS 270', 'Database Management', 3); V SELECT * FROM course; S ROLLBACK; R SELECT * FROM course; S -- chapter 3, Figure 3-6; p.90 SAVEPOINT course_save1;
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 3

Ch3AQueries - - File name: Ch3AQueries.sql - by J. Chen...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online