本文共 810 字，大约阅读时间需要 2 分钟。

Oracle???Oracle?????????????????????????????????Oracle??????????????????????????

????????????????????????SQL???

create sequence myseq    start with 1    increment by 1    nomaxvalue    minvalue 1;

????????myseq????????1???????1??????????????1?

?????????????????????????

select myseq.currval from dual;

??

select myseq.currtval from dual; -- ???currval?curr_val??????????????

?????????????????????????

alter sequence myseq    increment by 2; -- ???????2

?????????????????????????

drop sequence myseq;

??????????????????????????????????????Student???

insert into Student(id,name,age)values(    myseq.nextval,    '????',    25);

???????id??????myseq???????

????

• ????????????????????????
• ???????????globally unique identifier?GUC???????????
• ?????????????????????????????????

??????Oracle???????????????????????????