摘要： 序列1 序列对象可以被多个用户共享2 一般用于主键或唯一键3 select my_seq.currval from test;/***查看当前序列值，之前必须使用过my_seq.nextval***/CREATE SEQUENCE my_seqSTART WITH 1000INCREMENT BY 1NOCACHE/***CACHE 10(预先分配10个序列值)***/NOCYCLE;drop sequence my_seq;insert into test value(my_seq.nextval,'Allen',8000);索引1 单列索引(单列)和复合索引(多列)2 单列 阅读全文