Oracle 序列

create table testsequence ( userId number(10) primary key, userName varchar2(30))

create sequence JEECMSV93.sequence_testsequence
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;

select sequence_testsequence.nextval from dual; --- 第一次返回的初始化的序列号

select sequence_testsequence.currval from dual

select * from testsequence

insert into testsequence values(sequence_testsequence.nextval,'于吉利');