序列:
建:create sequence myseq
start 1
increament by 1
order
nocycle;
用:select myseq .nextval from books
注: select myseq.current from books
如果关机后(数据库),只能用myseq.nextval 查找当前值
比较容易影响性能
insert into books values(myseq.nextval,'a')
desc dba_sequences
调整 增量
alter sequence myseq
increament by 3
不能修改当前值