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

CASE#8

a)
CREATE SEQUENCE skill_id_sequence
start with 1
nomaxvalue;

b)
INSERT INTO skill
VALUES (skill_id_sequence.NEXTVAL,'VB.NET Programming');

INSERT INTO skill
VALUES (skill_id_sequence.NEXTVAL,'COBOL Programming');

INSERT INTO skill
VALUES (skill_id_sequence.NEXTVAL,'Java Programming');

c)
UPDATE skill
SET  skill_describtion='J++ Programming'
WHERE skill_id=3;

d)
GRANT select,insert,update
ON   skill
TO   PUBLIC;

e)
DELETE FROM skill;

f)
DROP SEQUENCE skill_id_sequence;