


SEQUENCE


シーケンスの作成
CREATE SEQUENCE SAMPLE_SEQ AS INT MAXVALUE 999999 CYCLE;



呼び出し
SELECT NEXT VALUE FOR SAMPLE_SEQ;



呼び出し
SELECT CURRENTVALUE FROM SYS.SYSSEQUENCES WHERE SEQUENCENAME='SAMPLE_SEQ'




呼び出し
values NEXT VALUE FOR SAMPLE_SEQ
