oracle之序列

序列

序列就是有顺序的数列。例如123456789.....

创建序列

-- 创建序列
create sequence seq_test minvalue 1 maxvalue 9999999999999999999 INCREMENT by 1 start with 1;

-- 当前值
--current value;

select seq_test.currval from dual;

-- 下一个值
-- next value;

select seq_test.nextval from dual;

select * from stu;

insert into stu (id,name)values(seq_test.nextval,'测试序列');