oracle SEQUENCE

我只想当个程序员

DROP SEQUENCE student_sequence;

CREATE SEQUENCE student_sequence START WITH 10000 INCREMENT BY 1;

DROP TABLE students;

CREATE TABLE students (

id NUMBER(5) PRIMARY KEY,

first_name VARCHAR2(20),

last_name VARCHAR2(20),

major VARCHAR2(30),

current_credits NUMBER(3),

grade varchar2(2));

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

VALUES (student_sequence.NEXTVAL, 'Scott', 'Smith', 'Computer Science', 98,null);

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

VALUES (student_sequence.NEXTVAL, 'Margaret', 'Mason', 'History', 88,null);

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

VALUES (student_sequence.NEXTVAL, 'Joanne', 'Junebug', 'Computer Science', 75,null);

INSERT INTO students (id, first_name, last_name, major, current_credits,grade)

VALUES (student_sequence.NEXTVAL, 'Manish', 'Murgratroid', 'Economics', 66,null);

commit;

posted on 2007-11-29 09:47 小高阅读(300) 评论(0) 编辑收藏

JUST DO IT ~