本文共 825 字，大约阅读时间需要 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???????????????????????????

转载地址：http://ulpfk.baihongyu.com/