创建一个序列(NewStudNo),初始值为10001,步长为1,最大值为99999
语法:create sequence 序列名
increment by n 序列增量
start with n 第一个序列值
maxvalue n
minvalue n
cycle | nocycle 是否循环
cache | nocache 内存中可以预分配的序列号个数
create sequence newstudno
increment by 1
start with 10001
maxvalue 99999
将农经01班的所有学生以题目3建立的序列号为学号存入新表StudInfoSequence中
create table studinfosequence
as
select * from studinfo;
truncate table studinfo;
insert into studinfosequence
select newstudno.nextval,studname,studsex,studbirthday,classid
from studinfo
where classid=
(
select classid from classinfo where classname='农经01'
)