Oracle Database シーケンスを作成する

CREATE SEQUENCE シーケンス名
  [ START WITH 初期値 ]
  [ INCREMENT BY 増分値 ]
  [ MAXVALUE 最大値 | NOMAXVALUE ]
  [ MINVALUE 最小値 | NOMINVALUE ]
  [ CYCLE | NOCYCLE ]
  [ CACHE キャッシュ数 | NOCYCLE ]
;

CREATE SEQUENCE seq
  START WITH 1
  INCREMENT BY 1
  MAXVALUE 1000
  MINVALUE 1
  CYCLE
;

SELECT seq.nextval FROM dual;
SELECT seq.nextval FROM dual;

SELECT seq.currval FROM dual;

insert into AGEDATA values (seq.nextval,10);