oracle創建序列基本語法:
CREATE?SEQUENCE?sequence?//創建序列名稱[INCREMENT?BY?n]?//遞增的序列值是n?如果n是正數就遞增,如果是負數就遞減?默認是1
[START?WITH?n]//開始的值,遞增默認是minvalue?遞減是maxvalue
[{MAXVALUE?n?|?NOMAXVALUE}]?//最大值
[{MINVALUE?n?|?NOMINVALUE}]?//最小值
[{CYCLE?|?NOCYCLE}]?//循環/不循環
[{CACHE?n?|?NOCACHE}];//分配並存入到內存中