标题：Oracle的序列使用方法

1楼

admin 发表于：2009/9/22 19:18:11

create sequence NEXTNUMBER start with 1000 increment by 1 maxvalue 2000 nocycle cache 20;

insert into student ("NUMBER") values(nextNumber.nextval);

select * from student

insert into student ("NUMBER","NAME") values(nextNumber.nextval,nextNumber.nextval);

select * from student

共1 条记录, 每页显示 10 条, 页签: [1]