创建序列
create sequence student_seq
increment by 1
start with 1
nomaxvalue
nocycle
cache 10引用序列
insert into student(student_id,....) values(student_seq.nextval,......)
create sequence student_seq
increment by 1
start with 1
nomaxvalue
nocycle
cache 10引用序列
insert into student(student_id,....) values(student_seq.nextval,......)
increment by 1
start with 1
nomaxvalue
nocycle
cache 10--在插入表的语句中这么用:insert into student values(seq_name.nextval,'王小二',.....) ;