Andre Long
CISP 350 Oracle
March 9, 2006
Chapter 3A PSC 

CASE#2
a)
CREATE SEQUENCE course_id_sequence
start with 2
nocache;

b)
INSERT INTO course(course_id, call_id)
VALUES(	course_id_sequence.NEXTVAL, 'MIS 301');
INSERT INTO course(course_id, call_id)
VALUES(	course_id_sequence.NEXTVAL, 'MIS 441');

c)
DELETE FROM course;

d)
DROP SEQUENCE course_id_sequence;